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
LVL 1
ramziabkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wilcoxonCommented:
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).
0
pcelbaCommented:
Sybase Adaptive server offers both ODBC and OLE DB drivers as a part of the package. More info: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35888.1550/doc/html/jon1256941734395.html

Depending on your SQL Server bit depth (32/64) you should install 32/64 bit OLE DB driver and use it for the Linked Server definition/creation. Remember: Nobody ensures the compatibility...

Linked Server requires OLE DB but you could also use Microsoft OLE DB Provider for ODBC drivers.

You may download the Sybase OLE DB provider here.

The older OLE DB version is not so compatible to SQL Server but you may try it...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ramziabkAuthor Commented:
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
0
pcelbaCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.