Re: DSNLess connection
- From: "Steven Burn" <somewhere@xxxxxxxxxxxxxxx>
- Date: Sun, 22 May 2005 17:27:02 +0100
No problem ;o)
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
"laura" <replyto@xxxxxxxxx> wrote in message news:eIUToouXFHA.3864@xxxxxxxxxxxxxxxxxxxxxxx
> Hello Steven,
>
> Thanks for your reply. There was another from Bob Barrows also which cleared
> my "string" up so that it would work - as it turns out, it looks as if I
> needed to add "Jet OLEDB:Database " before the word "Password".
>
> This database will be on an intranet, not visible to the outside world, and
> I will ensure it is an area not accessible by all the staff. It's going to
> hold usernames and passwords for those members of staff allowed to access
> certain areas of the intranet. Not sure if it's the best method, but so far
> it's the only method I've worked out.
>
> Many thanks for pointing that out to me and for your assistance.
>
> Regards,
> Laura TD
>
>
> "Steven Burn" <somewhere@xxxxxxxxxxxxxxx> wrote in message
> news:eA5zactXFHA.2124@xxxxxxxxxxxxxxxxxxxxxxx
> Firstly, DO NOT stick the database in reach of the outside world (stick it
> above the web root).
>
> As for the connection, give this a try;
>
> objDB = "\database\users.mdb"
> DSNName = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" +
> Server.MapPath(objDB) + ";Jet OLEDB:Database Password=letmein;"
>
> --
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
> "laura" <replyto@xxxxxxxxx> wrote in message
> news:eiT45WtXFHA.2420@xxxxxxxxxxxxxxxxxxxxxxx
> > Not sure if this is the right place to ask..
> >
> > I have a computer with Windows 98 on which I have set it up as a Personal
> > Web Server and I am running/testing a small Access database. I am working
> > from my XP computer in the same room, connected by network cable.
> >
> > I am confused as to which connection I should be using. I have to admit,
> > one
> > works (A), but I've been advised that I really should be using the other
> > (B).
> >
> > A) This works.
> >
> > DSNNAME = "Driver={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein;
> > DBQ="
> > & Server.MapPath("\databases\users.mdb")
> >
> > B) This does not work and this is what I believe I should be using:-
> >
> > 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?
> >
> > thanks
> > Laura TD
> >
> >
>
>
.
- References:
- DSNLess connection
- From: laura
- Re: DSNLess connection
- From: Steven Burn
- Re: DSNLess connection
- From: laura
- DSNLess connection
- Prev by Date: Re: DSNLess connection
- Next by Date: Re: distinct and sum
- Previous by thread: Re: DSNLess connection
- Next by thread: Re: DSNLess connection
- Index(es):
Relevant Pages
|
