SYBASE OLEDB CONFIGURATION
  Home FAQ Contact Sign in
sybase.public.connectivity.oledb only
 
Advanced search
POPULAR GROUPS

more...

sybase.public ... oledb Profile…
 Up
SYBASE OLEDB CONFIGURATION         


Date: May 22, 2008 17:56

Hi,

i'm a little bit in trouble. before i have syabase 12.x and
successfully linked our sybase database to sqlserver 2k and
2k5. when our company upgraded sybase to 15.x. i followed
the document
http://www.sybase.com/content/1029118/1029118.doc in linking
sybase 12.5 to sqlserver. but when i install the sybase
15.x openclient i can find the SYBASE OLEDB CONFIGURATION.
where i can find it?? or sybase change the SYBASE OLEDB
CONFIGURATION????

please help...

tengtium
1 Comment
Re: SYBASE OLEDB CONFIGURATION         


Date: May 22, 2008 20:55

I have used the doc you referenced 2 times when it was first published. I'm
not in the same environment so I'm a little rusty.
In swtching from ASE 12.x to ASE 15.x , you have switched from an oledb
driver written by a third party to a driver written by Sybase. The OLEDB
DATASOURCE tool no longer exists.

New Step #1. !!!! Get the latest EBF for the oledb client !!!! There have
been many fixes for linked server in the last year. The EBFs can be found
in the Software Development Kit... They will have a version of 15.0ESD#13.
(You at least want #12) The version of SDK looks older than your ASE
release but that is ok - they do not follow the same version sequence.

After installing the latest client ESD, jump to CONFIGURING MICROSOFT SQL
SERVER.
Do as instructed -
At step#4 choose SYBASE OLEDB Provider
At step#5 - Go to the connection tab and enter the datasource...
Show full article (1.80Kb)
no comments