Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ADO error for password DB

3 views
Skip to first unread message

AGP

unread,
Mar 26, 2002, 8:06:25 PM3/26/02
to
In DAO I could catch a very specific error number when trying to open a DB
that
was password protected. Now ive switched over to ADO and an error is
returned
but it seems to me that i might not catch the same number all the time. The
error retuned
is a large negative number and the description says "Invalid password". I
guess what im
asking is whats the best way to programatically (and with ADO) find out if a
DB
is password protected. Im using VB to open the database.

tia
AGP

Mike Collier

unread,
Mar 26, 2002, 9:05:23 PM3/26/02
to
You might have some luck examining the ADO connection errors collection
where further details can be found (Source, Help Context and native error).
We display them in our browser (Trial www.adoanywhere.com/cnet )

I have seen plenty of cases where programmers simply scan the error text for
'password'.


--
Michael Collier Bsc (Hons)

Interactive ADO Browser Trial www.adoanywhere.com/cnet
Free ADO Browser (FAB) www.adoanywhere.com/fab
Home Page www.adoanywhere.com
Email mi...@adoanywhere.com
--

"AGP" <sindiz...@softhome.net> wrote in message
news:lW8o8.135496$uA5.1...@rwcrnsc51.ops.asp.att.net...

Seshadri

unread,
Mar 27, 2002, 6:17:28 AM3/27/02
to
Please post your connection string and the snippet of code that is at the
problem and we can see if we can find anything we can help.

--
With Warmest Regards,
Seshadri

"AGP" <sindiz...@softhome.net> wrote in message
news:lW8o8.135496$uA5.1...@rwcrnsc51.ops.asp.att.net...

AGP

unread,
Apr 5, 2002, 12:47:40 AM4/5/02
to
It is a basic open connection. I just want to know what
is the best way to catch an error when my program tries
to open a password protected database. I was gonna
scan for password instead but depending on the local
language that might not always work.

ill try the error collection.

AGP

"Seshadri" <dks...@hotmails.com> wrote in message
news:uKXkJDY1BHA.2428@tkmsftngp07...

0 new messages