QueryTable.Connection sstrin syntax

A

Arvi Laanemets

Hi

Can someone explain, for what are parameters Network and Address in this
connection:

Activecell.QueryTable.Connection =
"ODBC;
DSN=Spektra;
Description=Spektra;
UID=UserID;
;
APP=Microsoft Office 2003;
WSID=ServerName;
DATABASE=Spektra;
Network=SomeString;
Address=SomeString, SomeNumber"


Thanks in advance!
Arvi Laanemets
 

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

Change Database that MS Query points to based on cell value Excel 3
ODBC Connection Question 1
syntax error in VBA in query from Access 0
Filling combobox from query 0
ODBC Connection problems 3
Remover ODBC Dialog Box 0
Getting WorkstationID 3
Run-time error '1004' general odbc error 3

Top