MySQL File DSN

[jeremybolduc]

Hello,
I'm having problems getting a MySQL file DSN to work. I'm using XP Pro SP2.
The SQL database is 4.1
The My SQL ODBC driver is 3.51.12.00

I can create a user or system dsn but NOT File Dsn. I tried to make one manually using notepad:
[ODBC]
DRIVER=MySQL ODBC 3.51 Driver
UID=root
PWD=password
SERVER=localhost
PORT=3306
OPTION=16834
DATABASE=hotspot

From within mySQL I've enabled network access. Is it posible to use a system dsn connection? Please help.
Thanks in advance
jeremy
_________________
jeremy a bolduc

[alan]

1) You have to use the ODBC Data Source Administrator program to generate file dsn. You shouldn't edit the dsn file directly nor using other dsn (i.e. user dsn, system dsn).

2) Due to the poor compatibility between different MySQL versions, you must use the exact version specified in our readme.rtf documentation. You can download MySQL ODBC 3.51.04 at http://downloads.mysql.com/archives/myodbc-3.51/MyODBC-3.51.04.exe
_________________
~ Patronsoft Limited ~

[jeremybolduc]

Hi Alan,
Well I uninstalled the newer ODBC driver and installed 3.51.04 and I can now connect to the database. I've repointed my Authentication Server to:
C:\Program Files\Common Files\ODBC\Data Sources\mysqlconn.dsn
No when I open users I get:
Client does not support authentication protocol requested by server, consider upgrading mysql client.
On the server I told it to use the old password encryption. Do you know of any other tricks to get this working with mysql?
Thanks again
jeremy
_________________
jeremy a bolduc

[alan]

Are you using MySQL 4.0.x (again see readme.rtf)? When you generate file dsn within ODBC Data Source Administrator, is it successful without errors?
_________________
~ Patronsoft Limited ~

[jeremybolduc]

I give up I'll stick with the dbf file. Thanks anyway.
_________________
jeremy a bolduc