Link to home
Start Free TrialLog in
Avatar of lanier3532
lanier3532

asked on

[ODBC SQL Server Driver][DBMSLPCN]Invalid Connection

I have an application in VB.Net using a connection via ADODB.connection.  We are in the process of moving our "stuff to the cloud".  The new server is Server 2016 and the database is SQL Server 2008 Express.  I have enabled the protocols in SQL Server for Named Pipes, TCPIP.  It appears that I have the Server/Database/User/Pwd info correct, but the connection object is not supported?

The connection string is similar to this:
"Driver={SQL Server};Server=SQL1\SQLEXPRESS;Database=Orders;UID=sa;pwd=Adg991!; providerName=System.Data.SqlClient"

Thanks for you help!
ASKER CERTIFIED SOLUTION
Avatar of Jonathan Kelly
Jonathan Kelly
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It also seems you are mixing ODBC and OLEDB. Look here for the correct connection string: https://docs.microsoft.com/en-us/office/vba/access/concepts/activex-data-objects/create-an-ado-connection-string

Additional connections string examples are here: https://www.connectionstrings.com/
sweet...