-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|