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\SQLEXP RESS;Datab ase=Orders ;UID=sa;pw d=Adg991!; providerName=System.Data.S qlClient"
Thanks for you help!
The connection string is similar to this:
"Driver={SQL Server};Server=SQL1\SQLEXP
Thanks for you help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sweet...
Additional connections string examples are here: https://www.connectionstrings.com/