How can I connect to a MSAccess database?
(If version matters, MSAccess 2000)
For example, I have the following for our SQL Server...
<addname="x"connectionString="Server=x.x.x.x;
Database=x; User Id=x; password=x"providerName="System.Data.SqlClient"/>
Is it the same providerName?
EDIT: Found it. :)
<add name="AccessDbConn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|db1.mdb; User Id=; Password=" providerName="System.Data.OleDb"></add>
Member
21 Points
47 Posts
Connecting to MSAccess database
Aug 17, 2011 09:35 AM|Program1235|LINK
Hello there,
How can I connect to a MSAccess database?
(If version matters, MSAccess 2000)
For example, I have the following for our SQL Server...
<add name="x" connectionString="Server=x.x.x.x; Database=x; User Id=x; password=x" providerName="System.Data.SqlClient"/>
Is it the same providerName?
EDIT: Found it. :)
<add name="AccessDbConn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|db1.mdb; User Id=; Password=" providerName="System.Data.OleDb"></add>