We help IT Professionals succeed at work.

[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!
Comment
Watch Question

Enable Remote Connections on SQL Config Settings
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/