472,117 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,117 software developers and data experts.

ODBC Connection keeps dropping off...


I have a local user on our network running MS Access 2003 (on Win XP
Home), which needs to connect to a Back-End MySQL DB on our Cobalt
Qube 3 Server.
I installed the correct software to run the Access on their Win XP OS,
and installed the ODBC MySQL Driver 3.51.

When I test the connection in the ODBC panel, CONNECTED !
Then I open MS Access, and great, the app works.

If I then close MS Access and re-open, as soon as I hit a button which
needs data from MySQL then I get an error stating that this IP cannot
connect to the MySQL DB using Password (Yes). I have tried taking the
password out of the DSN, and user account for MySQL, but this makes no

After the second time trying to open MS Access, it brings up the ODBC
Admin panel, and I have to delete the password and try to connect,
'connection failed', then enter the password 'connected!'. If I then
open Access it runs, if I then exit & re-start the app 'Cannot connect
using IP........., using Password...)

I have double checked all the settings in the DSN, and their user
account for the MySQL DB.

Surely, the PC should be able to connect either all the time, or not
at all, not just once, and then lose the connection ????

Can anyone help me on this ?
Jul 20 '05 #1
0 1779

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by The VanDerbeck Group | last post: by
2 posts views Thread by CriticalJ | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.