Re: DSNLess connection

laura wrote:
>
> DSNNAME = "Provider=Microsoft.Jet.OLEDB.4.0; User
> ID=;Password=letmein; Data Source=" &
> server.mappath("\databases\users.mdb") & ";"
> This is the error message I get with Option (B):-
>
> Microsoft JET Database Engine error '80040e4d'
> Cannot start your application. The workgroup information file is
> missing or opened exclusively by another user.
> /check_user.asp, line 42
>
>
> Could it be that the password is not working? It does work in Option
> (A), but not in Option (B). The database has been password protected
> with password "letmein". What am I doing wrong?


Since your database is not using workgroup security, you should not be using
a user name and password. It looks as if your database is password-secured
(which is futile security at best). If so, your connection string should
look like this (from www.carlprothman.net):

DSNNAME = "Provider=Microsoft.Jet.OLEDB.4.0; Jet OLEDB:Database
Password=letmein; Data
Source=" & server.mappath("\databases\users.mdb") & ";"


HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages
Loading