SearchSearch   ProfileProfile   Log inLog in   RegisterRegister 

MySQL File DSN

 
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum
View previous topic :: View next topic  
Author Message
jeremybolduc



Joined: 23 Jun 2006
Posts: 11
Location: Oxford Airport

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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
Display posts from previous:   
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum All times are GMT
Page 1 of 1

 
Jump to:  
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