OLE DB initialization string

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hello -

I'm using VB .Net 2003 connected to Access 2002 via the OLE DB Jet Engine
driver. When I open the connection in the Server Explorer, it works fine.
But when I build the app I get this error:

"Format of the initialization string does not conform to the OLE DB
specification" from the Microsoft OLE DB Service Components.

I can't find anything about what is causing this error. The Data Connection
has very few options, and this is not obvious.

Thanks for your assistance.

Mark
 
* "Mark said:
I'm using VB .Net 2003 connected to Access 2002 via the OLE DB Jet Engine
driver. When I open the connection in the Server Explorer, it works fine.
But when I build the app I get this error:

"Format of the initialization string does not conform to the OLE DB
specification" from the Microsoft OLE DB Service Components.

I can't find anything about what is causing this error. The Data Connection
has very few options, and this is not obvious.
Click to expand...

What's your connection string?
 
Hi Cor -

Is the connection string the same as the initialization string? I'm not
sure if they are the same.

Thanks for the links.
 
Hi Mark,

This I did copy from something in MSDE

[oledb]
Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Persist Security Info=False;Data
Source=a-iresmi2000;Initial Catalog=Northwind;Integrated Security=SSPI

And that is what I call a connection string.

Cor
 
Good question! I'm not settnig a value myself. The Form appears to set all
those values itself based on the Data Connection I defined - and it has no
option for the connection string, although it says it can connect
successfully.
 
Back
Top