Re: DSNLess connection

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)