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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
LINKING A SYBASE DATABASE ON MS SQL SERVER
- Thread starter EPNICO
- Start date
Create a ODBC link (System DSN) to the Sybase database on the server where SQL server runs. Create a linked server within SQL server (Enterprise Manager: Server -> Security -> Linked Servers -> Linked server) which points to this ODBC.
General tab:
Linked server: <name you want to use to call sybase database>
Server type: other datasource: Microsoft OLE DB provider for ODBC drivers
Product name: <name of ODBC driver as showed in driver screen of ODBC's>
Data source: <name of your system DSN>
General tab:
Linked server: <name you want to use to call sybase database>
Server type: other datasource: Microsoft OLE DB provider for ODBC drivers
Product name: <name of ODBC driver as showed in driver screen of ODBC's>
Data source: <name of your system DSN>
- Status
Similar threads
- Locked
- Question
- Locked
- Question