Re: DSNLess connection

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
>
>


.

Relevant Pages

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)
  • Re: ESQL/C documentation nightmare
    ... documentation about explicit and implicit connections. ... CONNECTION connection statements for new applications of Version 6.0 ... the SQL database statements (such as ...
    (comp.databases.informix)