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...
"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:8l********************************@4ax.com...
On Wed, 9 Jul 2003 00:55:43 -0700, "Serge Calderara"
<se*************@maillefer.net> wrote:
¤ 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 ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)