| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO Connection to SQL Server
The solution !
There are two parameters for the Connection string. The one I had missing was: Network = xxxxxxx Another that is relevant for dynamic port machines (?) seems to be the: Address = yyyyyyy,port Hope it works for others. I have just run the spreadsheet from a machine that needed no configuration of ODBC etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL Server Connection Pooling | Excel Programming | |||
| ADO connection problem when using server | Excel Programming | |||
| ado connection to access vs. sql server? | Excel Programming | |||
| Check for valid SQL server connection | Excel Programming | |||
| sql server connection | Excel Programming | |||
Hybrid Mode
