mySQL ODBC ADODB Connection String Issues

[recarv]

Hello,

I've written an extensive set of macros and forms which utilize a mySQL database via myODBC and ADODB and it has been and continues to work fine when I use the connection string and refer to a system or use DSN using a mySQL database.

Recently, due to a change in IP addresses, I ventured to try to change the ADODB connection string from just the DSN=DSN NAME to

Driver={MySQL ODBC 3.51 Driver };"_
& "Server= 127.0.0.1;" _
& "DATABASE=test;"_
& "UID=test;"_
& "PWD=pass"

Now here is the most irritating part - it works on some queries which seem to be smaller queries not involving any major joins or extensive computation time, but it freezes excel other times when multiple queries and recordsets are open.

Can someone guess what I might be doing wrong because I really don't want to go back to using the DSN because its a pain to make every user change the IP of the DSN all the time.

Thanks incredibly, in advance.

R

[recarv]

Oh,

and the connection sits idle - its not computation thats keeping it from finishing. I've also tried closing the ADODB.Connection object at the end of the function.