προσπέλαση βασης δεδομένων απο Visual Basic

[alan2]

Εχω ορίσει

 

dbprovider=".NET Framework Data Provider for OLE DB"
dbsource="C:\Users\Spyros\Documents\Visual Studio 2010\Projects\myoffice0\myoffice0\myoffice0\Database1.mdb"

 

con.ConnectionString = dbprovider & dbsource

 

Το λάθος χτυπάει στην εντολή

 

con.Open()

 

οπoυ λέει

The '.NET Framework Data Provider for OLE DB Data Source = C:\Users.......\Database1.mdb' provider is not registered on the local machine.

Επεξ/σία 2 Ιουνίου 2013 από alan2

[nucleus]

Από το παρακάτω

 

http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx

 

Διαβάζοντας το σημείο .NET Framework Data Provider for OLE DB

 

 

The .NET Framework Data Provider for OLE DB (OleDb) uses native OLE DB through COM interop to enable data access. The .NET Framework Data Provider for OLE DB supports both local and distributed transactions. For distributed transactions, the .NET Framework Data Provider for OLE DB, by default, automatically enlists in a transaction and obtains transaction details from Windows Component Services. For more information, see Transactions and Concurrency.

 

The following table shows the providers that have been tested with ADO.NET.

  Driver Provider

SQLOLEDB

Microsoft OLE DB provider for SQL Server

MSDAORA

Microsoft OLE DB provider for Oracle

Microsoft.Jet.OLEDB.4.0

OLE DB provider for Microsoft Jet

Note:

Using an Access (Jet) database as a data source for multithreaded applications, such as ASP.NET applications, is not recommended. If you must use Jet as a data source for an ASP.NET application, realize that ASP.NET applications connecting to an Access database can encounter connection problems.

 

 

 

 

Θα δεις ότι χρησιμοποιείς λανθασμένη τιμή στην μεταβλητή dbprovider για το connection string σου.Μιας και θες να χρησιμοποιήσεις Access τότε πρέπει ο provider σου να είναι Microsoft.Jet.OLEDB.4.0 οπότε

dbprovider="Microsoft.Jet.OLEDB.4.0"
dbsource="C:\Users\Spyros\Documents\Visual Studio 2010\Projects\myoffice0\myoffice0\myoffice0\Database1.mdb"

con.ConnectionString = dbprovider & dbsource

Υποθέτω ότι κάνεις Import το System.Data.OleDb στο αρχείο vb σου.