ODBC .Net Data Provider question

[info25]

Hi
I've installed ODBC .Net Data Provider and MDAC 2.7 on my web server, but why does it always give error when I use the System.Data.ODBC namespace?

The import part of my code is as follows:
<%@ Import Namespace=&quot;System.Data&quot; %>
<%@ Import Namespace=&quot;System.Data.Odbc&quot; %>
<%@ Assembly Name = &quot;System.Data.Odbc&quot; %>

The error is:
Parser Error Message: File or assembly name System.Data.Odbc, or one of its dependencies, was not found.

The server:
Windows2000, SQL server 7

I've tried changing System.Data.Odbc to Microsoft.Data.Odbc (since that's what I saw on some sites), but the result is the same. Can someone tell me what I've been missing out?
Thanks!

 

[jfrost10]

Hey info,

Have you checked to make sure that the dll is actually on your machine, and that it installed in the place its looking for?

Also, if you're using sql server, you may want to look into using the System.Data.SQLClient, which is made to work specifically with sql server connections.

Jack

ps Where did you download the odbc .NET provider from? Just wondering so I can add it to my system.