Re: Unable to connect to MSAccess database

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Ken Schaefer (kenREMOVE_at_THISadOpenStatic.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 19:55:20 +1000

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://>/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 http://www.developersdex.com ***
: Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Unable to connect to MSAccess database
    ... i m trying to connect to msaccess database from an asp page in the same ... Error Type: ... after doing some research, i checked the MDAC. ...
    (microsoft.public.inetserver.asp.db)
  • mysql and mythtv
    ... could not connect to the database". ... 2005-11-23 13:48:51.441 No error type from QSqlError? ... Strange... ...
    (alt.os.linux.suse)
  • Re: Creating Shareware Database App in VB 6
    ... is using a newer version of access to open the database. ... CR files will amount to about 3 to 10 MB ... MDAC will be about 5MB compressed. ... My app is a database to ...
    (microsoft.public.vb.database)
  • Re: Class not registered error when using Web
    ... One of my clients using a .NET WinApp connecting to an MS Access database on ... They were running a lower version of MDAC though. ... Please install MDAC 2.6 or later." ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: cant access databases publisher 2002
    ... Can you open the database file in Works? ... Look at the Works newsgroup. ... I have tried to update the MDAC and I get "MDAC 2.8 RTM is ... Have you downloaded the component checker to see if you have any MDAC ...
    (microsoft.public.publisher)