Avatar of ramziabk

asked on 

Sybase Adaptive server

I have Sybase database and Microsoft SQL 2008 on windows 2008 R2 64 bit.
I need to know what should be installed from Sybase so that I can create a Linked server at the SQL level?

Microsoft SQL Server 2008Microsoft SQL ServerMicrosoft SQL Server 2005Sybase DatabaseDatabases

Avatar of undefined
Last Comment
Pavel Celba
Avatar of wilcoxon
Flag of United States of America image

By "Linked server", do you mean the ability to reference databases on one server from the other server without opening a new connection directly to the other server?

If so, I don't think there is a way to do this.  As far as I know, Sybase does not support this sort of linking.

Disclaimer: I am not a DBA so I could be wrong (but I have been using ASE for 15 years).
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of ramziabk


Thank you Pcelba,

I've downloaded and installed OLE DB as requested. Using dsedit I was able to ping the Sybase server successfully. However, If I go to MS SQL, Linked Server and under Provider List, I can't see Sybase OLE DB. I can Only see Advantage OLE.

And even if I run ODBCAD32, i.e. the 64 bit version, I can't see the Sybase OLE. Only under SysWOW64 i.e. the 32 bit version I can see the connection!!!!

Any idea how to solve this?

Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

You cannot see OLE DB providers under ODBCAD32 which serves ODBC drivers only.

If you see Advantage OLE under providers in SQL Server then try it.

If it does not help then you could find OLE DB provider as a part of the Free "Developer" Edition: http://scn.sap.com/community/developer-center/oltp-db

Of course, the driver compatibility depends on the Server version you have available. OLE DB driver is always included in the installation package.
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo