Unable to connect to MSAccess database

[Joe Abou Jaoude]

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]

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" <joe30@hotmail.com> wrote in message
news:eEua72eJEHA.2660@TK2MSFTNGP09.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!

[Joe Abou Jaoude]

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!