format of the initialization string does not conform to specification starting at index 0

I'm trying to create a connection to a microsoft access database file (.mdb) in my App_Data folder.  When I go to the solution explorer and try to create a new connection, I click the change button and select Microsoft Access Database File.  The next screen prompts me to enter the connection string manually, but I continue to get the error "format of the initialization string does not conform to specification starting at index 0"

See the attached screeshot of the screen where I have to manually enter the connection string.

Any ideas what the problem is?

Thanks.
screenshot.png
-Dman100-Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
drypzConnect With a Mentor Commented:
Hi! Have you tried to change your connection string? something like

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\RGN.mdb;User Id=admin;Password=;

You can change the Data Source where your db located.
0
 
-Dman100-Author Commented:
Hi drypz,

I tried modifying the connection string and adding the full path to the access database:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Dwayne\My Documents\Visual Studio 2008\Projects\Sample Code\Projects\Web Apps\ConfigureLocalAccessConnection\App_Data\RGN.mdb;User Id=admin;Password=;

I still got the same error message.
0
 
drypzCommented:
Hi! Try to download and install the latest MDAC version from microsoft.
0
All Courses

From novice to tech pro — start learning today.