Server Connection Error

  • Thread starter Thread starter JerryH
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

database connection vba ADODB & ADOX 2
Connection String - SQL Server Express 5
error vsto application can't access connection string in app.confi 0
Connecting to SQL Server via VBA and ADO 1
ADO Connection to SQL Server 3
ADO retrieval from close workbook-data type issue 2
SQL Server Connection Pooling 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top