My attempts to open a Jet database in CSharp .Net fail. I am trying the
following:
string cstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and
Settings/.../Data/List.mdb;Connect Timeout=5";

OleDbConnection sdb = new OleDbConnection(cstr);

sdb.Open();

but the Open generates an OleDbException. Is there soemthing wrong with the
connection string?

Thanks

--
Peter Aspey
-------------------------------------------------------
email: replace 6 by p

Typically, the error message will have more specifics: unauthorized user,
could not find file, etc. What message is in the exception?

"Peter Rabbit" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> My attempts to open a Jet database in CSharp .Net fail. I am trying the
> following:
> string cstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents
and
> Settings/.../Data/List.mdb;Connect Timeout=5";
>
> OleDbConnection sdb = new OleDbConnection(cstr);
>
> sdb.Open();
>
> but the Open generates an OleDbException. Is there soemthing wrong with
the
> connection string?
>
> Thanks
>
> --
> Peter Aspey
> -------------------------------------------------------
> email: replace 6 by p
>
>

On Mon, 14 Jul 2003 21:27:57 +0200, "Peter Rabbit" <(E-Mail Removed)> wrote:

¤ My attempts to open a Jet database in CSharp .Net fail. I am trying the
¤ following:
¤ string cstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and
¤ Settings/.../Data/List.mdb;Connect Timeout=5";
¤
¤ OleDbConnection sdb = new OleDbConnection(cstr);
¤
¤ sdb.Open();
¤
¤ but the Open generates an OleDbException. Is there soemthing wrong with the
¤ connection string?

Yes, you need to escape the slash character in your database file path:

OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\My
Documents\\db1.mdb");


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)

Thanks for your response. After enclosing the Open function in a 'try'
clause, the Exception object gave the message:
"Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done."

I don't know if that helps. "Each OLE DB status value" - where do I find
these values?

--
Peter Aspey
-------------------------------------------------------
email: replace 6 by p

"Marina" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Typically, the error message will have more specifics: unauthorized user,
> could not find file, etc. What message is in the exception?
>
> "Peter Rabbit" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > My attempts to open a Jet database in CSharp .Net fail. I am trying the
> > following:
> > string cstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents
> and
> > Settings/.../Data/List.mdb;Connect Timeout=5";
> >
> > OleDbConnection sdb = new OleDbConnection(cstr);
> >
> > sdb.Open();
> >
> > but the Open generates an OleDbException. Is there soemthing wrong with
> the
> > connection string?
> >
> > Thanks
> >
> > --
> > Peter Aspey
> > -------------------------------------------------------
> > email: replace 6 by p
> >
> >
>
>

Sorry, the quote I gave was misleading. I had tried forward slashes. The
backslashes are in fact 'escaped' in the real version, and the problem is
the same.

Thanks
--
Peter Aspey
-------------------------------------------------------
email: replace 6 by p

"Paul Clement" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Mon, 14 Jul 2003 21:27:57 +0200, "Peter Rabbit" <(E-Mail Removed)>
wrote:
>
> ¤ My attempts to open a Jet database in CSharp .Net fail. I am trying the
> ¤ following:
> ¤ string cstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents
and
> ¤ Settings/.../Data/List.mdb;Connect Timeout=5";
> ¤
> ¤ OleDbConnection sdb = new OleDbConnection(cstr);
> ¤
> ¤ sdb.Open();
> ¤
> ¤ but the Open generates an OleDbException. Is there soemthing wrong with
the
> ¤ connection string?
>
> Yes, you need to escape the slash character in your database file path:
>
> OleDbConnection objConn = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\My
> Documents\\db1.mdb");
>
>
> Paul ~~~ (E-Mail Removed)
> Microsoft MVP (Visual Basic)

Open now works! I limited the arguments in the connection string to
'Provider' and 'Data Source' only (i.e. removed the 'Connect Timeout').
So don't waste any time on my last message!
Thanks again

--
Peter Aspey
-------------------------------------------------------
email: replace 6 by p

"Marina" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Typically, the error message will have more specifics: unauthorized user,
> could not find file, etc. What message is in the exception?
>
> "Peter Rabbit" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > My attempts to open a Jet database in CSharp .Net fail. I am trying the
> > following:
> > string cstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents
> and
> > Settings/.../Data/List.mdb;Connect Timeout=5";
> >
> > OleDbConnection sdb = new OleDbConnection(cstr);
> >
> > sdb.Open();
> >
> > but the Open generates an OleDbException. Is there soemthing wrong with
> the
> > connection string?
> >
> > Thanks
> >
> > --
> > Peter Aspey
> > -------------------------------------------------------
> > email: replace 6 by p
> >
> >
>
>

On Tue, 15 Jul 2003 19:20:10 +0200, "Peter Rabbit" <(E-Mail Removed)> wrote:

¤ Sorry, the quote I gave was misleading. I had tried forward slashes. The
¤ backslashes are in fact 'escaped' in the real version, and the problem is
¤ the same.

Could you post the code with the exact connection string you are using.


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)

On Tue, 15 Jul 2003 19:40:12 +0200, "Peter Rabbit" <(E-Mail Removed)> wrote:

¤ Open now works! I limited the arguments in the connection string to
¤ 'Provider' and 'Data Source' only (i.e. removed the 'Connect Timeout').
¤ So don't waste any time on my last message!

In that case ignore my follow-up question.


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)