1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Data Adapter Configuration Wizard

Discussion in 'Software Development' started by FreddyFudpucker, Jul 26, 2007.

Thread Status:
Not open for further replies.
  1. FreddyFudpucker

    FreddyFudpucker Thread Starter

    Joined:
    Feb 20, 2007
    Messages:
    14
    I'm trying to connect a C# program to an Access database, but the wizard keeps crashing every time... Here's as far as I can get...

    Move OLEDBDataAdapter to current form.
    Wizard opens up
    Click "New Connection"
    Click "Change"
    Select "Microsoft Access Database File" from combo box.
    Click "OK"
    Type "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="C:\\Data\\TimeSheet.mdb;" into the ConnectionString text box (tried leaving it blank as well).
    Click "Test Connection"
    Receive "Test connection succeeded." message box
    Click OK
    Click OK to continue wizard

    This is where I receive the error message, which is

    "Format of the initialization string does not conform to specification starting at index 0."

    If I set up the connection, data adapter, and dataset in the program itself, I don't have any problem, just if I try to use the wizard. Also tried to set it up in VB .NET, but have the exact same problem. Thanks in advance.
     
  2. pjhutch

    pjhutch

    Joined:
    Aug 23, 2005
    Messages:
    429
    Try specifying just the folder name and not the filename, you can specify the file later in the code.
     
  3. FreddyFudpucker

    FreddyFudpucker Thread Starter

    Joined:
    Feb 20, 2007
    Messages:
    14
    Tried that, but had no success. Exact same error message.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/601090

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice