SYBASE OLEDB CONFIGURATION

[tengtium]

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

[Cory Sane]

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 at HOST,PORT
for your ASE Server.
(or use the advanced tab and fill in other options like "interface file
path" etc- see oledb manual for options)
I'm not sure about steps 6-7.
The rest should be the same as before.
HTH
--
Cory Sane
[Member of TeamSybase]
Certified Sybase Associate DBA for ASE 15.0
not a Sybase Inc. employee
<tengtium> wrote in message news:4836163a.45...@sybase.com...