connection - runtime error (Excel to SQL-Sever) 1

[kingz2000]

HI Guys,

I'm getting a connection problem when I try to open an adodb.connection to SQL-Server

Run-time error 2147217805(80040e73) Format of the initialization string does not conform to the OLE DB specification

I get the error on the con.open statement.

Here is my code:

Private Sub exec_SQL(strSQL As String)
Dim rowsAffected As Integer
Dim con As ADODB.Connection
Set con = New ADODB.Connection

con.Open "Driver={SQL Server];Server=X;Database=XX;uid=XXXX;pwd=XXXXX;"

con.Execute strSQL, rowsAffected
con.Close


End Sub

 

[bborissov]

This is ODBC connection string, not OLE DB.
Check

https://www.connectionstrings.com/sql-server/

for correct string

Borislav Borissov
VFP9 SP2, SQL Server

 

[kingz2000]

thanks dude