Connecting to Access 2000 database???

  • Thread starter Thread starter Serge Calderara
  • Start date Start date
S

Serge Calderara

Dear all,

what is the way of accessing to an acess database
with .Net?

With SQL server there is an SQL data provider but cannot
found for access?

thanks for your reply
Serge
 
Serge Calderara said:
what is the way of accessing to an acess database
with .Net?

With SQL server there is an SQL data provider but cannot
found for access?
Click to expand...

There is the "Microsoft Jet 4.0 OLE DB Provider". Try to add a connection in
the server explorer window and select the mentioned provider in the first
folder. You can have the required connection string created this way.

For further ADO.Net related questions:
microsoft.public.dotnet.framework.adonet

See also the comprehensive docs about accessing data in the Framework SDK
and the VB docs (called "Accessing data").
 
¤ Dear all,
¤
¤ what is the way of accessing to an acess database
¤ with .Net?
¤
¤ With SQL server there is an SQL data provider but cannot
¤ found for access?
¤

Just a snippet using the OLEDB objects:

Dim ConnectionString As String

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\db1.mdb"
Dim AccessConn As New System.Data.OleDb.OleDbConnection(ConnectionString)
AccessConn.Open()


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
To get the connection string for your specific connection use the UDL wizard
(Uniform Data Link).

Create an empty file with the extention of .udl, double click on it and the
wizard will launch, once completed with the wizard you required connection
string will be in the file, in fact you can us the 'from file' option to
actually connect based on the files content.

There are many other ways to get connection string, and many other ways to
utilize the dll in which the UDL Wizard resides, this is just one.

Byron...

 
Back
Top