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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked server to ODBC not ole db

Status
Not open for further replies.
robsuttonjr

robsuttonjr

MIS
Sep 17, 2001
673
US
I am trying to add a connection to an older database. The odbc driver is not an 'OLE DB' provider. So when I drop down the list I don't see this old driver. How can add this as a linked server? I tried the ole db for odbc but cannot figure it out. Anybody know if its posstible to setup a linked server with a system dsn?

The more I learn the more I find I know nothing.

Rob
 
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question
Parameterised sql server query
Replies
8
Views
776
Chriss Miller
C
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
974
Volvere
V
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
2K
Chris Miller
Chris Miller
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
942
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top