asp.net connects to sybase by oledb

[bshen]

I have a data access dll developed using oledb ado.net to connect to
Sybase12 in c#.net frame work 1.1. It works in .net window application
or .net command line application. But a simple data query in asp.net
using iis5.1 fails with the following error message:

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

[InvalidOperationException: The 'Sybase ASE OLE DB Provider' provider
is not registered on the local machine.]

Any help is appreciated.

Bing

 

[William \(Bill\) Vaughn]

Sounds like the Sybase Managed Provider DLL is not properly registered in
the assembly manifest so it gets copied to the client system.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[bshen]

Thank you Bill, can you give me more detail?

The sybase client is installed in a network drive and I have Path
pointing to it. The .net window application works, is there anything
additional I need to do for asp.net to connect to Sybase with OLEDB.

 

[William \(Bill\) Vaughn]

I expect that the ASP system cannot see the provider... that's the
fundamental issue. I would consult the Sybase folks to see what they
recommend for ASP.NET rigs.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________