error when trying to add data connection

14 Jun 2006 2:47 PM

BJ

I want to add data connection on access database and every time I'm getting
the same error:

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

I'm using Microsoft Access Database File (OLE DB) with this connection
string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\cm.mdb"

can anyone help??
tnx

14 Jun 2006 3:57 PM

Paul Clement

On Wed, 14 Jun 2006 16:47:45 +0200, "BJ" <bern***@hi.hinet.hr> wrote:

¤ I want to add data connection on access database and every time I'm getting
¤ the same error:
¤
¤ "format of the initialization string does not conform to specification
¤ starting at index 0"
¤
¤ I'm using Microsoft Access Database File (OLE DB) with this connection
¤ string:
¤ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\cm.mdb"

Is this what the connection string looks like in code? I'm trying to figure out where you copied it
from?

Paul
~~~~
Microsoft MVP (Visual Basic)

14 Jun 2006 4:00 PM

Jim Hughes

Any chance you are using C#?

If so, the \ character needs to be doubled (escaped)

Or the string variable needs to have an @ symbol

String connstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=d:\cm.mdb"

Show quote

"BJ" <bern***@hi.hinet.hr> wrote in message
news:e6p7c6$v37$1@magcargo.vodatel.hr...
>I want to add data connection on access database and every time I'm getting
>the same error:
>
> "format of the initialization string does not conform to specification
> starting at index 0"
>
> I'm using Microsoft Access Database File (OLE DB) with this connection
> string:
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\cm.mdb"
>
> can anyone help??
> tnx
>

15 Jun 2006 3:28 AM

Otis Mukinfus

Show quote

On Wed, 14 Jun 2006 16:47:45 +0200, "BJ" <bern***@hi.hinet.hr> wrote:

>I want to add data connection on access database and every time I'm getting
>the same error:
>
>"format of the initialization string does not conform to specification
>starting at index 0"
>
>I'm using Microsoft Access Database File (OLE DB) with this connection
>string:
>"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\cm.mdb"
>
>can anyone help??
>tnx
>

That message is caused by a registry setting that has been removed (probably by
a registry cleaning application).

From MSDN Forums... It worked for me.

***************************************************************************

Hi everyone,

I have determined what seems to be causing the problem, but I would like to
verify that this is the cause for all of you that have seen the problem.

Please run regedit.exe and browse to the following location in the tree:

HKEY_CLASSES_ROOT\CLSID\{F9AE8980-7E52-11d0-8964-00C04FD611D7}

Underneath this key should be a sub-key called "ProgID" with a value of
"MSIDXS.1". If you can't find this, it is causing the problem you are seeing.
Adding this back should fix the issue.

Please let me know if this does not solve the problem. We will see if it is
possible to fix the code that makes some assumptions about the existence of this
key to have some default behavior that works even if it does not exist.

Thanks,
Stephen

--------------------------------------------------------------------------------
Visual Studio Data Team

Report Abuse

*****************************************************************************

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com