SQL Clients

Help Robot
, , , ,
1

Hello,

We have a few jobs that use a “.NET Framework Data Provider for SQL Server” for the datasource in the connection string. The SQL server we are connecting to had the SQL Client 2012 which is End of Life. So it was uninstalled. When we did this, the jobs failed on our BOTS so we changed to use the “.NET Framework Data Provider for OLE DB”. When we clicked on the datasource connection drop down, we could see the databases.

We had to reinstall the SQL Client 2012 on the SQL server and now when we use the prior “.NET Framework Data Provider for SQL Server” we are not able to see the databases in the connection string. How do I correct this? Is something corrupted?

2

An empty database dropdown doesn’t necessarily mean corruption. Try entering the server and database name manually, then test under the same Windows account used by the Robot.

Also check the actual provider: System.Data.SqlClient and OLE DB/SQLNCLI11 are different. If the connection uses a native driver, verify it on the Robot machine, not only the SQL server, and check its bitness.

Please share the exact error, provider name and a connection string with credentials removed. That will distinguish a driver problem from authentication or database access.