Cannot Create Data Connection

[JamesJ]

Just installed Visual Basic 2005 Express Edition. Off to a
very fast start. When attempting to link to a data source which
is a ms access database I get the following error (if I wrote it
down properly).
Format of the initialization string does not conform to
specification starting at 0.

I thought it would be a bit easier to expose the project to
my data, but no.

Any help will be appreciated.
James

 

[Guest]

Unfortunately, nothing is easy when you're talking about databases. If
you're new to the subject, definitely get a good book on ADO.NET and read up
about it. There's lots to take into consideration and many pitfalls.

As for your specific problem, I'm not sure what you're doing in the code,
but it sounds like you have a malformed connection string. Check out
www.connectionstrings.com for some hints on what to do. Unfortunately, the
website just has examples; there isn't much info as to why its this way or
that way. But its a quick place to start from.