ODBC error 80004005 - Couldn't find installable ISAM.

[Jason SmithSpencer]

Hi,

I am trying to connect to an access database which is stored on an NT server
running IIS4.
The following code gives the error:

Microsoft JET Database Engine error '80004005'

Couldn't find installable ISAM.

/ASPTestArea/1stnametest.asp, line 30


The code creating it is:
Dim dcnDB 'As ADODB.Connection
Dim strDatabaseLocation 'As String
Dim rsName 'As ADODB.Recordset
Dim strSQL 'As String
Dim blnAddedWhere 'As Boolean

strDatabaseLocation = _
"c:\inetpub\wwwroot\ASPTestArea\internalfirstname.mdb"
Response.Write "1. DataBase location has been set"
Set dcnDB = Server.CreateObject("ADODB.Connection")
Response.Write "2. Connection object has been created"
dcnDB.ConnectionString = _
"Provider=Microsoft.jet.OLEDB.3.51;" _
& strDatabaseLocation
Response.Write "3. ConnectionString has been created."
dcnDB.Open("DSN=TestASP")
Response.Write "4. Connection Object has been opened."
dcnDB.Close
Response.Write "5. Connection Object has been closed."

You will have to forgive the 'Response.Write' Messages. This is for training
purposes.

I would apppreciate you help on this.

Jason.

[Don W]

Hey Jason,

What operating system are you running? What version of MDAC (Microsoft Data
Access Componants) do you have installed?
and what version of access are you using?



"Jason SmithSpencer" <jsmithspencer@hhh.co.uk> wrote:
>
>Hi,
>
> I am trying to connect to an access database which is stored on an NT server
>running IIS4.
>The following code gives the error:
>
> Microsoft JET Database Engine error '80004005'
>
>Couldn't find installable ISAM.
>
>/ASPTestArea/1stnametest.asp, line 30
>
>
>The code creating it is:
>Dim dcnDB 'As ADODB.Connection
> Dim strDatabaseLocation 'As String
> Dim rsName 'As ADODB.Recordset
> Dim strSQL 'As String
> Dim blnAddedWhere 'As Boolean
>
> strDatabaseLocation = _
> "c:\inetpub\wwwroot\ASPTestArea\internalfirstname.mdb"
> Response.Write "1. DataBase location has been set"
> Set dcnDB = Server.CreateObject("ADODB.Connection")
> Response.Write "2. Connection object has been created"
> dcnDB.ConnectionString = _
> "Provider=Microsoft.jet.OLEDB.3.51;" _
> & strDatabaseLocation
> Response.Write "3. ConnectionString has been created."
> dcnDB.Open("DSN=TestASP")
> Response.Write "4. Connection Object has been opened."
> dcnDB.Close
> Response.Write "5. Connection Object has been closed."
>
>You will have to forgive the 'Response.Write' Messages. This is for training
>purposes.
>
> I would apppreciate you help on this.
>
> Jason.

[Don W]

Hey Jason,

What version of MDAC (Microsoft Data Access Componants) do you have installed?
and what version of access are you using?



"Jason SmithSpencer" <jsmithspencer@hhh.co.uk> wrote:
>
>Hi,
>
> I am trying to connect to an access database which is stored on an NT server
>running IIS4.
>The following code gives the error:
>
> Microsoft JET Database Engine error '80004005'
>
>Couldn't find installable ISAM.
>
>/ASPTestArea/1stnametest.asp, line 30
>
>
>The code creating it is:
>Dim dcnDB 'As ADODB.Connection
> Dim strDatabaseLocation 'As String
> Dim rsName 'As ADODB.Recordset
> Dim strSQL 'As String
> Dim blnAddedWhere 'As Boolean
>
> strDatabaseLocation = _
> "c:\inetpub\wwwroot\ASPTestArea\internalfirstname.mdb"
> Response.Write "1. DataBase location has been set"
> Set dcnDB = Server.CreateObject("ADODB.Connection")
> Response.Write "2. Connection object has been created"
> dcnDB.ConnectionString = _
> "Provider=Microsoft.jet.OLEDB.3.51;" _
> & strDatabaseLocation
> Response.Write "3. ConnectionString has been created."
> dcnDB.Open("DSN=TestASP")
> Response.Write "4. Connection Object has been opened."
> dcnDB.Close
> Response.Write "5. Connection Object has been closed."
>
>You will have to forgive the 'Response.Write' Messages. This is for training
>purposes.
>
> I would apppreciate you help on this.
>
> Jason.