MAK (Muthusamy Anantha Kumar)
Linked server to Sybase 12 ASE database :
Install and Configure Sybase Client
The first step in this process is to install Sybase 12
ASE drivers on the SQL Server box. Then create an ODBC system DSN to Sybase.
Get the IP address, database name, userID, password and port number used in
Sybase server, from the Sybase database admin. The Sybase client reads
information about Sybase from a configuration file under \Sybase\ini\sql.ini
file. (Example appears below). Change or create the following information in
the sql.ini file.
2000 server use this (remove comma between port and ip address):
ODBC system DSN for Sybase server on the SQL Server Box.
Create Linked Server for Sybase
Open the Enterprise
manager, and right click on Linked server under the Security Folder. Create a
new linked server. Select the OLE DB Provider for ODBC Drivers. Give the same
system ODBC name that you created for Sybase in the textbox provided for Data
Source. Provide a userid and password in the provider string and security tab.
connection by running the following SQL command in query analyzer.
Select * from openquery(SybaseServer, "Select column1 from table1")