By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,966 Members | 1,986 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,966 IT Pros & Developers. It's quick & easy.

Connecting to MDB in DotNet Application

P: n/a
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?
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
* "Meir Rotfleisch" <me**@mrrcomputers.cc> scripsit:
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 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>
Nov 20 '05 #2

P: n/a
On Tue, 28 Oct 2003 16:49:56 +0200, "Meir Rotfleisch" <me**@mrrcomputers.cc> wrote:

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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.