How to use DSN connection here.....

  • Thread starter Thread starter Bob Scoze
  • Start date Start date
B

Bob Scoze

I am using VB.Net and ADO.Net.

My code to open Access database is as follows.

dim dbConnection as string ="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\db1.mdb;"
dim myDBConnection as OLEDBConnection = New OleDbConnection(dbConnection)
myDBConnection.Open()

this code works fine.

My questions is how to use DSN(Data source Name)(Which points to the same
database) in the connection string.
I am looking for exact syntax.
thanks
Bob
 
Back
Top