Connecting to ASE 12.5 from a .NET application tusing OLE DB

[B.Hemalatha]

I am using the following code in an .aspx file

dim oCon as new OleDbConnection()

oCon.ConnectionString="Provider =
SybaseASEOLEDBProvider;" & _
"Server Name=10.15.1.35,5101;" & _
"Initial Catalog=testdb;" & _
"User id=abcdef;" & _
"Password=xxxxx;"
oCon.Open()

But it reports the following error:

[OleDbException (0x80040154): No error information
available: REGDB_E_CLASSNOTREG(0x80040154).]

[InvalidOperationException: The 'SybaseASEOLEDBProvider'
provider is not registered on the local machine.

Any idea how to overcome this and connect to ASE?

Thanks in advance.

Hemalatha

[Paul]

Hi Hemalatha

Provider should be Sybase.ASEOLEDBProvider (notice the "." after Sybase)

Also - this is the OEM provider and vendor will not support use on .NET.
Sybase distributes another Provider
(ASEOLEDB) - included in SDK 12.5.1 and 15.0 distribution, and with the ASE
PC Client CD (12.5.3 and up I believe).
You can try this also.

To confirm you have both installed, a quick check of these folders:

OEM:
%SYBASE%\OLEDB, filename sydaase.dll

Sybase:
%SYBASE%\DataAccess\OLEDB\dll , filename sybdrvoledb.dll

-Paul

<B.Hemalatha> wrote in message news:45e2d77d.3b8...@sybase.com...

[Hemalatha]

Hi Paul ,

Many thanks. It worked.

Hemalatha

[jubr...@gmail.com]

Hello,

I check the file path for the OEM dll but could not find it. Please what do i need to do?