Forum Discussion

frank_vanderstr's avatar
frank_vanderstr
Contributor
9 years ago
Solved

Cannot Connect to New Database Server using ADO

I have created automation scripts that used an ADO command object to connect to our internal server's databases and make several select, update and insert statements, and that would run great.   We...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
9 years ago
Copy Link
Just out of curiosity. ... have your tried creating an ADO query object instead of a command object? Or just simply create and ADO Connection object just to make sure that works. It seems strange that the connection string works fine in TC in one specific situation but not when creating ADO objects, almost like the new permissions are preventing certain kinds of operations
frank_vanderstr's avatar
frank_vanderstr
Contributor
9 years ago
Copy Link

I have not tried creating and ADO query object, as the ADO command was the most easy for me to understand and execute in code.

 

Permissions might be the culprit, but the user on SQL has the needed permissions for executing Selects and Updates.

 

Connecting seems to work but when I go to execute a sql statement I get the error.