SQL Database connection error
Posted on 2011-10-27
I have an application that talks to a backend SQL 2008 server. This application used to be on a SQL 2005 server, and was moved to a SQL 2008 server. When I moved it, I did not have all of the users created on the SQL 2008 server so my database had some orphaned users. I have since resolved that, and everything is working as expected for the most part, EXCEPT:
This database is connected to by a client program called ServiceCEO (Insight Direct). The SQL server is defined using a system DSN in the client OS ODBC. For all systems that were previously connected to the application, we were able to change the DSN to the new server and the database connected without any issue.
HOWEVER, for NEW clients (clients that never had the program installed), after we set the DSN to the correct server and try to connect, we get the following error:
ADODB.Command Error: Requested operation requires an OLE DB Session object, which is not supported by the current provider. (3709)
All existing clients are able to connect without any issue, but all new clients get this error. Does anyone know what I can do to resolve this?