asked on 7/20/2015

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?

Thanks

Microsoft SQL Server 2008 Microsoft SQL Server Microsoft SQL Server 2005 Sybase Database Databases

Last Comment

Pavel Celba

7/21/2015

wilcoxon

7/20/2015

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).

ASKER CERTIFIED SOLUTION

Pavel Celba

7/20/2015

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

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

ramziabk

7/21/2015

ASKER

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?

Regards
Ramzi

Pavel Celba

7/21/2015

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.