Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How Do I Call the ODBC Administrator with Excel VBA

Status
Not open for further replies.
shager

shager

Technical User
Jan 8, 2003
3
US
I used to use this Excel VBA code to open the ODBC Administrator

ConnectionId = SQLOpen("", ThisWorkbook.Sheets("CNString").Range("A1"), 2)

My problem is that SQLOpen is part of XLODBC which is getting old. The things I read suggest using something within ADO but I can not figure it out.

The end result is that I want to call the ODBC Administrator so that I can get it to build my Connection String.
 
Status
Not open for further replies.

Similar threads

dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
498
dcern
dcern
Rudraya
  • Locked
  • Question
failed connecting odbc
Replies
0
Views
513
Rudraya
Rudraya
Antonius222
  • Locked
  • Question
Must the driver use SQLGetPrivateProfileString?
Replies
0
Views
160
Antonius222
Antonius222
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
808
k5tm
k5tm
ceil32
  • Locked
  • Question
ODBC Connection - Windows 7 64 Bit
Replies
0
Views
485
ceil32
ceil32

Part and Inventory Search

Sponsor

Back
Top