Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    22

    Unanswered: DSNless connection issues Access 2003 ASP

    Hi I want to connect my asp pages to Access 2003, I am using the DSNless connection it works fine when I don’t put a password on my Access database.

    When I put a password on my database I get the following error:

    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for


    This is my connection string which I use to connect to Access:

    MM_cnnDisertation_STRING = "DRIVER=Microsoft Access Driver (*.mdb);Dbq=C:\Inetpub\wwwroot\db\db1.mdb;PWD=pass word;"

    My database is in a separate directory from my webpages

    Any help would be most appreciated,

    Rob

  2. #2
    Join Date
    Oct 2005
    Posts
    178
    You need the Jet engine.

    Try tis connection string

    SConnStr= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\yourdata.mdb"

  3. #3
    Join Date
    Dec 2003
    Posts
    22
    Cheers used the Microsoft Jet engine and it works fine

  4. #4
    Join Date
    Oct 2005
    Posts
    178

    Smile

    I'm very glad to help you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •