Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 688
  • Last Modified:

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
0
-Dman100-
Asked:
-Dman100-
  • 2
1 Solution
 
drypzCommented:
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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now