DSNLess connection

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

  • ppp on OpenVMS AlphaServer hardware port for remote gui access
    ... We need help in configuring a PPP TCP/IP connection so that developers ... When a database is on a remote Windows server: ... We have software running on an OpenVMS AlphaServer acting as host ...
    (comp.os.vms)
  • Re: PlatformNotSupportedException with Sql Server 2000 sp3a
    ... > The project is well configured to deploy the soft on the mobile computer. ... >> Post the connection string. ... >>> I having a Sql Server 2000 on windows Xp and i have to use a Symbol MC ... >>> connected on a the database located on Windows Xp's computer. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: connection options to yukon
    ... If these are asp.net apps connecting to the database, ... If you use TLS you can increase the security of your SQL ... > Windows auth can lead to trojan operations as the application using SSPI ... >> Connection pooling does not depend on what method you choose to connect - ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: 80004005 Unspecified Error
    ... > Microsoft JET Database Engine error '80004005' | ... > Sub Database() ... > 'smack around the db connection until it lets go ...
    (microsoft.public.inetserver.asp.db)
  • Re: DSNLess connection
    ... DO NOT stick the database in reach of the outside world (stick it ... above the web root). ... > I am confused as to which connection I should be using. ... > Microsoft JET Database Engine error '80040e4d' ...
    (microsoft.public.inetserver.asp.db)