This is related somewhat to my other topics regarding data access using ASP.NET...but its specific so I made a new thread...

I have an ASP 3.0 script that works perfectly...I am updating this page to ASP.NET.  Basically the page runs a simple query on a database using ODBC. I have used the SAME connection string in my .NET page as I do in my ASP page...but I get this error...

[Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

I have encountered errors from the database before in my ASP 3.0 pages regarding permission settings...it is very finicky...does .NET use a different kind of Windows user permissions than ASP 3.0? I have both pages, the 3.0 and .NET in the same Windows virtual directory and the 3.0 works...

Any ideas?


So I tried to Use OleDB in .NET instead...and I get this message...

The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).

Using "Provider=MSDASQL" in my connection string instead of a DSN...so i take it this attempt is still using an ODBC method of connecting(?)

The database I am connecting to is a proprietary format and although it comes with an ODBC driver I am not sure how to connect with OleDB...but it would sure be nice though!...there is no support and no documentation for the database at all. How can I possibly know whether connecting with Ole is even possible? perhaps all I need to do is determine the provider(?)



[Edited by ~Bean~ on 20-04-2005 at 01:56 PM GMT]

____________________________
Eggheads unite! You have nothing to lose but your yolks.

I have figured out the first error it was a permissions problem as I suspected.



____________________________
Eggheads unite! You have nothing to lose but your yolks.