Professional Web Applications Themes

Unable to connect to MSAccess database - ASP Database

i m trying to connect to msaccess database from an asp page in the same folder several days ago without any success,so any help would me much appreciated. I have windows 2000 and msaccess 2000 set conn= server.CreateObject("adodb.connection") conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE: C:\Inetpub\wwwroot\Al\Callig.mdb" i got this error: Error Type: Provider (0x80040E4D) Authentication failed. although there's no password for the database, then i tried this connection string with same error result: conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE:" & Server.MapPath("Callig.mdb") after doing some research, i added "Trusted_Connection=yes" to the connection string and i got another type of error: Error Type: Microsoft JET Database Engine (0x80004005) Could ...

  1. #1

    Default Unable to connect to MSAccess database

    i m trying to connect to msaccess database from an asp page in the same
    folder several days ago without any success,so any help would me much
    appreciated.
    I have windows 2000 and msaccess 2000

    set conn= server.CreateObject("adodb.connection")
    conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE:
    C:\Inetpub\wwwroot\Al\Callig.mdb"

    i got this error:
    Error Type:
    Provider (0x80040E4D)
    Authentication failed.

    although there's no password for the database, then i tried this
    connection string with same error result:

    conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE:" &
    Server.MapPath("Callig.mdb")

    after doing some research, i added "Trusted_Connection=yes" to the
    connection string and i got another type of error:

    Error Type:
    Microsoft JET Database Engine (0x80004005)
    Could not find installable ISAM.

    after doing some research, i checked the MDAC. i have MDAC 2.7 sp1
    REFRESH, so i reinstalled it as many sites suggest it, and restat the
    computer, but same problem, i m still getting the same error.

    so now i don't have any clue to what to do.
    any suggestion would be appreciated
    THX.


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Joe Abou Jaoude Guest

  2. #2

    Default Re: Unable to connect to MSAccess database

    You need
    Data Source=c:\inetpub\wwwroot\ai\callig.mdb
    not
    Data Source:c:\inetpub\wwwroot\ai\callig.mdb

    Ensure that you set IIS permissions properly if you put you database inside
    your webroot, otherwise someone can download it by doing:
    http://<yourserver>/ai/callig.mdb

    Best it place it in it's own separate folder, then remove IIS Read
    permissions.

    Cheers
    Ken



    "Joe Abou Jaoude" <joe30hotmail.com> wrote in message
    news:eEua72eJEHA.2660TK2MSFTNGP09.phx.gbl...
    : i m trying to connect to msaccess database from an asp page in the same
    : folder several days ago without any success,so any help would me much
    : appreciated.
    : I have windows 2000 and msaccess 2000
    :
    : set conn= server.CreateObject("adodb.connection")
    : conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE:
    : C:\Inetpub\wwwroot\Al\Callig.mdb"
    :
    : i got this error:
    : Error Type:
    : Provider (0x80040E4D)
    : Authentication failed.
    :
    : although there's no password for the database, then i tried this
    : connection string with same error result:
    :
    : conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE:" &
    : Server.MapPath("Callig.mdb")
    :
    : after doing some research, i added "Trusted_Connection=yes" to the
    : connection string and i got another type of error:
    :
    : Error Type:
    : Microsoft JET Database Engine (0x80004005)
    : Could not find installable ISAM.
    :
    : after doing some research, i checked the MDAC. i have MDAC 2.7 sp1
    : REFRESH, so i reinstalled it as many sites suggest it, and restat the
    : computer, but same problem, i m still getting the same error.
    :
    : so now i don't have any clue to what to do.
    : any suggestion would be appreciated
    : THX.
    :
    :
    : *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    : Don't just participate in USENET...get rewarded for it!


    Ken Schaefer Guest

  3. #3

    Default Re: Unable to connect to MSAccess database

    thanks ken, it was a typo error...
    about putting my database in web root, well i m using it internally, not
    on a web server, so i don't have this problem of someone downloading the
    database.




    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Joe Abou Jaoude Guest

Similar Threads

  1. Unable to connect to SQL server database
    By toby007 in forum Coldfusion Server Administration
    Replies: 1
    Last Post: March 15th, 01:41 PM
  2. #26116 [Fbk->Opn]: Unable to connect to ODBC database
    By andrew at howells-solicitors dot com in forum PHP Development
    Replies: 1
    Last Post: November 5th, 05:22 PM
  3. #26116 [Opn->Bgs]: Unable to connect to ODBC database
    By kalowsky@php.net in forum PHP Development
    Replies: 0
    Last Post: November 5th, 01:09 PM
  4. #26116 [Opn->Fbk]: Unable to connect to ODBC database
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: November 5th, 05:42 AM
  5. #26116 [NEW]: Unable to connect to ODBC database
    By andrew at howells-solicitors dot com in forum PHP Development
    Replies: 0
    Last Post: November 4th, 03:41 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139