Connecting to MDB in DotNet Application

  • Thread starter Thread starter Meir Rotfleisch
  • Start date Start date
M

Meir Rotfleisch

Hi

Newbie to DotNet ! I am trying to connect to a Access 2000 MDB . When I
try to drag the Table to the form I get the following error


You cannt usa an OLE DB Provider for ODBC Drivers


Suggestions?
 
* "Meir Rotfleisch said:
Newbie to DotNet ! I am trying to connect to a Access 2000 MDB . When I
try to drag the Table to the form I get the following error

You cannt usa an OLE DB Provider for ODBC Drivers
Click to expand...

You will have to use the corresponding classes for Odbc, namely
'OdbcConnection' (available only in .NET 1.1). But I think it's
possible to access an Access database with OleDb too, have a look at
<http://www.connectionstrings.com> for more information.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

Improve your quoting style:
<http://learn.to/quote>
<http://www.plig.net/nnq/nquote.html>
 
¤ Hi
¤
¤ Newbie to DotNet ! I am trying to connect to a Access 2000 MDB . When I
¤ try to drag the Table to the form I get the following error
¤
¤
¤ You cannt usa an OLE DB Provider for ODBC Drivers

You should be using the Microsoft Jet 4.0 OLE DB Provider and not the OLE DB Provider for ODBC
Drivers. Modify the connection information on the Data Link Properties dialog so that your Access
Data Connection uses this provider.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top