ASEOLEDB Provider Error trying to create linked MSSQL server

[salinj]

Have installed ASE15 OLEDB provider (version 15.0.0.320)
ESD#14 on my MSSQLServer 2005 box and successfully created a
DataSource for my Sybase server. When trying to create a
linked server the ASEOLEDB provider does not appear as a
valid provider in the list. Thinking it may be a registry
problem. Initally installed 12.5 and then tried to
uninstall this version before installing ASE15. Can someone
tell me what registry entries I should see for ASEOLEDB?
Also what should the LIB and PATH variables look like?

[Paul]

Hi

Try this:

First PATH should have %SYBASE%\DataAccess\OLEDB\dll

Use regsvr32 to register:

cd %SYBASE%\DataAccess\OLEDB\dll

regsvr32 sybdrvoledb.dll

This updates teh registry correctly.

Make sure you can use the Sybase configurator to create a data source - this
would confirm the registry works (run sybdrvadm.exe from
%SYBASE%\DataAccess\bin)

-Paul

<salinj> wrote in message news:488a2a6a.3fd...@sybase.com...

[salinj]

> I have confirmed my PATH looks like this. My dll is
registered. And I can create a data source. But when I go
into SQL Server Management Studio and right-click on
PROVIDERS the ASEOLEDB provider does not appear in the list.
Any other ideas?

[Paul]

Hi

Do you see "Sybase OLEDB Provider" ? This is the text name for "ASEOLEDB".
Try that one if you see it.

-Paul

<salinj> wrote in message news:48a0879b.638...@sybase.com...