Server Connection Error

J

JerryH

While trying to make a connection to our server using SQLOLEDB I get an
'Invalid Connection String Attribute' error. Is there a way to determine what
part of the connection string is bad?
thanks,
Jerry
 
P

Patrick Molloy

Using ADO, your connection string should look something like this:

"PROVIDER=MSDASQL;driver={SQL
Server};server=MySQLserverName;uid=;pwd=;database=MyDatabaseName;"

just replace the server name and the database name
 
Top