Ok,

I'm not sure if this is quite the place, but I wanted to see if anyone has experienced similar problems with myODBC using ADODB connections with VB.

When I give the connection string as simply a DSN name everything works fine, but when I use the IP address, user,pass, etc as options instead so I can change the IP address if needed and redistribute the software easily certain things hang in Excel VBA and I have to end the task.

Has anyone else experienced this?

R

Ok,

So, I figured out what might be the answer in case this ever gets archived and might save hundreds of people hours of hassle with DSN's

After you close the Connection Object, set it to Nothing:

Set Cnxn = Nothing

Works like a charm, sorry for the bother. Archive this.

R