Visual Studio .NET Data Connection to MS ACCESS
Posted on 2004-08-19
I am using VS .NET 2003, and have several Data Connections set up to SQL Servers. Now though, I want to add a Data Connection for a .mdb file on my F: network drive. I set up an ODBC connection to it, this ODBC connection works fine. But there is no option in the Data Conenction configuration tool to use the ODBC connection, on the Provider tab.
Basically I want to get the connection string to put in my web.config file, if some knows how to put together a connection string to a .mdb file that would work for me too.
I tried to use the OLEDB Simple Provider driver in the Provider tab, but this did not work, it didn't recognize my F: drive path.