469,080 Members | 1,747 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,080 developers. It's quick & easy.

ODBC Connection keeps dropping off...

Hi,

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
difference.

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 ?
Thanks
David.
Jul 20 '05 #1
0 1663

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
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.