| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Server Connection Error
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Server Connection Error
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 "JerryH" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel VBA connection to SQL Server using ADO | Excel Programming | |||
| ADO Connection to SQL Server | Excel Programming | |||
| ADO connection problem when using server | Excel Programming | |||
| ado connection to access vs. sql server? | Excel Programming | |||
| sql server connection | Excel Programming | |||
Linear Mode
