connection string to access database failing (ado.net)
I am trying to connect to the MS access database...using the following connection string
connString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\Northwind.mdb"
and the error it displays is
Unknown connection option in connection string....
I think it should be simple and straight forward..Am I doing any mistake?
Pls suggest...
nath
thank you so much...but I still get the error 'unknown connection option in connecti
unknown connection option in connection string provider...
The connection string is ...
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Northwind.mdb;User ID=Admin;Password="
Private idbConn As SqlConnection = Nothing
idbConn = New SqlConnection(connString)