ODBC error 80004005 - Couldn't find installable ISAM.


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: ODBC error 80004005 - Couldn't find installable ISAM.

  1. #1
    Jason SmithSpencer Guest

    ODBC error 80004005 - Couldn't find installable ISAM.


    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.

  2. #2
    Don W Guest

    Re: ODBC error 80004005 - Couldn't find installable ISAM.


    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.



  3. #3
    Don W Guest

    Re: ODBC error 80004005 - Couldn't find installable ISAM.


    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.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center