Re: Connection to MySQL with gdafe

[Rodrigo Moya <rmoya tsai es>]

Bjorn Andersson wrote:

> I recently tried gnome-db for the first time. I am trying to
> connect to my MySQL database with gdafe, but it doesn't seem
> to connect for some reason. Here is some debug output:
>
>  gda-connection.c: 210: gda_connection_init called
>  gda-connection.c: 89: gda_connection_real_open called
>  IOR:01bb4c401e00000049444c3a4744412f436f6e6e656374696f6e466163746f72793a312e30005c4002000000caaedfba3c00000001010000260000002f746d702f6f726269742d62616e2f6f72622d353535383938353538313132313737393735000000080000000000000001000000000000002800000001010000100000006d796d6c616e2e6c696669782e666900e90c2d35080000000000000001000000
>  GDA_Connection_open returns -1
>  real_disconnect() called!
>  gda-connection.c: 129: gda_connection_real_close called
>
> This is my .gnome/gdalib file:
>
>  [Datasources]
>  MySql=MySQL
>
>  [MySQL]
>  provider=gda-mysql
>  dsn=DATABASE=test;HOST=localhost
>  Description=MySQL Test Database in native mode
>  Configurator=None
>
> Can somebody recommend some way for me to figure out my problem?
> I am using gnome-db 0.0.90.
>
> Thanks in advance for any help,
> Björn
>

Your configuration is ok, what is not ok is the MySQL server, which is currently broken. It's got some bugs that do not let him work as it might. You'll have to wait some time before it's usable. In the meantime, you may want to try accessing your MySQL database with the ODBC server (you must find a valid MySQL ODBC driver),
or try the postgres or oracle servers.

Cheers