View previous topic :: View next topic |
Author |
Message |
jeremybolduc
Joined: 23 Jun 2006 Posts: 11 Location: Oxford Airport
|
Posted: Mon Sep 11, 2006 1:25 pm Post subject: MySQL File DSN |
|
|
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 |
|
Back to top |
|
|
alan Forum facilitator
Joined: 26 Sep 2003 Posts: 4435
|
Posted: Tue Sep 12, 2006 2:46 am Post subject: |
|
|
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 ~ |
|
Back to top |
|
|
jeremybolduc
Joined: 23 Jun 2006 Posts: 11 Location: Oxford Airport
|
Posted: Tue Sep 12, 2006 8:25 am Post subject: Progress |
|
|
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 |
|
Back to top |
|
|
alan Forum facilitator
Joined: 26 Sep 2003 Posts: 4435
|
Posted: Tue Sep 12, 2006 8:51 am Post subject: |
|
|
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 ~ |
|
Back to top |
|
|
jeremybolduc
Joined: 23 Jun 2006 Posts: 11 Location: Oxford Airport
|
Posted: Wed Sep 13, 2006 12:46 pm Post subject: Never Mind |
|
|
I give up I'll stick with the dbf file. Thanks anyway. _________________ jeremy a bolduc |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
Powered by phpBB © 2001, 2005 phpBB Group
| |