To accomplish this, click on the Security tab in the left hand pane and provide Sybase credentials as shown below

Since we dont have the facility to enter the credential details in ODBC, we need to update the details here.

Provide the name for the Linked server, Select Other Data Source Option button, Select Provider as Microsoft OLE DB Provider for ODBC Drivers and provide the ODBC name in the field Data Source.

New Linked server window will popup, fill all the details required.

Expand Server Objects in object explorer and right click on Linked Servers folder and then click on New Linked server in the menu as shown below.

Open Management studio and connect to the SQL Server Instance.

Now you have created the ODBC connection successfully, the next step is to create a new linked server in SQL Server.

Now another window will pop up to enter the password, just enter the credential and click OK as shown below

Now you will be shown with the ODBC driver configuration, all the fields in the window are self explanatory hence fill all the details required (you can also go to other tabs for other ODBC options) and click on Test Connection button to test the ODBC connection.

When you click on Add button a list of ODBC drivers available in the system will be shown, select Adaptive Server Enterprise (this will not be displayed if you havent installed Sybase ODBC Drivers) and then click finish button.

In the ODBC admin window go to System tab as shown below.

Once installation completed go to Run> Type odbcad32 and press enter.

Install the Sybase driver from the downloaded setup.

Please note from Sybase ASE 15, Sybase will not ship the 3rd party DataDirect ODBC driver, Sybase has developed their own ODBC driver and it will be shipped.

Download Sybase ODBC drivers from the link Get Sybase ODBC Driver.

Sybase DBName : sqlarticles (authors table with 4 test records) In this case we need Sybase driver in client machine, this is not included in windows so you need to download it from Sybase Website. For creating ODBC connection we need the ODBC drivers for that RDBMS platform. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. We are going to create a linked server to SYBASE database server from SQL Server environment and then going to query datas from Sybase. In this article we going to look into creating a heterogeneous linked server.

Sql server error 64