[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Using ODBC.NET (odbcnet.msi) with ASP.NET Web Service

Austin Hackett

4/18/2002 11:08:00 PM

I'm attempting to access our ODBC data using the ODBC.NET
provided under the Microsoft.Data.Odbc Namespace using
the Microsoft.Data.Odbc.Dll reference.

I've been able to access the data just fine using the
OdbcConnection and OdbcDataAdapter on a WinForm.

However, trying to do so on an ASP.NET Web Service
generates an exception when I declare the OdbcConnection
object.

I've tried using the ODBC Driver for the OleDbAdapter,
but it would not work even on a WinForm whereas the
OdbcAdapter contained within Microsoft.Data.Odbc/ODBC.NET
worked fine.

It's looking like we should just drop our legacy database
and just go with SQL if we are truly serious about
plunging into this .NET stuff.


Is there going to be a 'WEB' update for this ODBC.NET
technology. Am I doing something boneheaded, where my
code works on a WinForm but not a WebService? Is it a
fault with the third-party ODBC driver?

Any thoughts?
1 Answer

Phil Enriquez

4/22/2002 8:06:00 PM

0

Even though the documentation said that Microsoft.Data.Odbc namespace gets added to the Global Assembly Cache during installation, it still does not get loaded by the Import Namespace statement.

What worked for me was copying Microsoft.Data.Odbc.dll to the /bin directory under /wwwroot.

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysof...
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...