Dot Net Access to tradebase database

2 messages Options
Embed this post
Permalink
Luis Robles

Dot Net Access to tradebase database

Reply Threaded More More options
Print post
Permalink
Hello I am trying to connect my visual studio dev environment to the tradebase database. I installed the windows installer version of marketcetera 0.5. I have installed the mysql gui tools and have tried to connect to: hostname localhost:8882 database=marketcetera uid=marketcetera pwd=marketcetera. The tools recognize a database present at these coordinates however I get the following error:

could not connect to the specified instance.
MySql Error Number 1130
Host 'XXXXX' is not allowed to connect to this MySQL server.

Is there something special I need to do to allow software other than tradebase to connect to the MySQL instance?

Thanks in advance!
Luis


_______________________________________________
m-etc-dev mailing list
[hidden email]
http://lists.marketcetera.org/mailman/listinfo/m-etc-dev_lists.marketcetera.org
toli

Re: Dot Net Access to tradebase database

Reply Threaded More More options
Print post
Permalink
Luis,

Are you connecting from a different machine? In that case, you may
need to modify the MySQL configuration file to allow for connections
coming from other machines.

Modify the my.ini file in Marketcetera\mysql directory, and include
this in the [mysqld] section:

bind-address            = 0.0.0.0

Otherwise, the default is to listen only on localhost, which disallows
connectivity from other machines.
See http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
for more information - there may be other issues.

Can you connect from command line using the mysql binary that's in the
marketcetera/mysql/bin directory? You can run this command
<marketcetera>\mysq\bin\mysql -u marketcetera -p marketcetera
and supply marketcetera as the password.

hope this helps

On Fri, Dec 5, 2008 at 11:12 AM, Luis Robles <[hidden email]> wrote:

> Hello I am trying to connect my visual studio dev environment to the
> tradebase database. I installed the windows installer version of
> marketcetera 0.5. I have installed the mysql gui tools and have tried to
> connect to: hostname localhost:8882 database=marketcetera uid=marketcetera
> pwd=marketcetera. The tools recognize a database present at these
> coordinates however I get the following error:
>
> could not connect to the specified instance.
> MySql Error Number 1130
> Host 'XXXXX' is not allowed to connect to this MySQL server.
>
> Is there something special I need to do to allow software other than
> tradebase to connect to the MySQL instance?
>
> Thanks in advance!
> Luis
>
>
> _______________________________________________
> m-etc-dev mailing list
> [hidden email]
> http://lists.marketcetera.org/mailman/listinfo/m-etc-dev_lists.marketcetera.org
>
>



--
Toli Kuznets
http://www.marketcetera.com: Open-Source Trading Platform
download.run.trade.

_______________________________________________
m-etc-dev mailing list
[hidden email]
http://lists.marketcetera.org/mailman/listinfo/m-etc-dev_lists.marketcetera.org