G
Guest
Why would an odbc connection through vba work sometimes, but not always?
I have written code to connect to SQL Server and it will run several times
with no problem, then suddenly it stops working. I haven't changed anything
in my code and I've checked to verify that it is passing the username and
password to the ODBC Connection string.
I've been researching the problem, but I haven't found anything to solve it
yet and I'm hoping one of you experts can point me in the right direction.
Any help would be appreciated.
Arlene
I have written code to connect to SQL Server and it will run several times
with no problem, then suddenly it stops working. I haven't changed anything
in my code and I've checked to verify that it is passing the username and
password to the ODBC Connection string.
I've been researching the problem, but I haven't found anything to solve it
yet and I'm hoping one of you experts can point me in the right direction.
Any help would be appreciated.
Arlene