|
 |
asp_database_setup thread: Could not find installable ISAM
Message #1 by Cdeen1@h... on Fri, 30 Nov 2001 18:58:04
|
|
Has anyine seen this error before? If so what the resolution?
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
/movie/connect.asp, line 25
My Script:
<%Option Explicit%>
<HTML>
<HEAD>
<TITLE>Testing our connection</TITLE>
</HEAD>
<BODY>
<%
Dim adOpenForwardOnly, adLockReadOnly, adCmdTable
adOpenForwardOnly = 0
adLockReadOnly = 1
adCmdTable = 2
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
Dim strDatabaseType
'Choose one of the following two lines, and comment out the other
strDatabaseType = "Access"
'strDatabaseType = "MSDE"
'Now we use this selection to open the connection in the appropriate way
If strDatabaseType = "Access" Then
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=" & server.mappath("Investcalendar.mdb") & _
"Persist Security Info=False"
Else
objConn.Open "Provider=SQLOLEDB;Persist Security Info=False;" & _
"User ID=sa;Initial Catalog=Movie;" & _
"Initial File Name=C:\MSSQL7\Data\Movie2000.mdf"
End If
objRS.Open "Movies", objConn, adOpenForwardOnly, adLockReadOnly, adCmdTable
While Not objRS.EOF
Response.Write objRS("Title") & "<BR>"
objRS.MoveNext
Wend
objRS.Close
objConn.Close
Set objRS = Nothing
Set objConn = Nothing
%>
</BODY>
</HTML>
Thanks
Message #2 by "Carlos Mario Medina Restrepo" <CMedina@I...> on Fri, 30 Nov 2001 14:12:23 -0500
|
|
Try with:
objConn.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _
"DBQ=3D" & server.mappath("Investcalendar.mdb") & _
"; Persist Security Info=3DFalse"
-----Original Message-----
From: Cdeen1@h... [mailto:Cdeen1@h...]
Sent: Friday, November 30, 2001 1:58 PM
To: ASP Database Setup
Subject: [asp_database_setup] Could not find installable ISAM
Has anyine seen this error before? If so what the resolution?
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
/movie/connect.asp, line 25
My Script:
<%Option Explicit%>
<HTML>
<HEAD>
<TITLE>Testing our connection</TITLE>
</HEAD>
<BODY>
<%
Dim adOpenForwardOnly, adLockReadOnly, adCmdTable
adOpenForwardOnly =3D 0
adLockReadOnly =3D 1
adCmdTable =3D 2
Dim objConn, objRS
Set objConn =3D Server.CreateObject("ADODB.Connection")
Set objRS =3D Server.CreateObject("ADODB.Recordset")
Dim strDatabaseType
'Choose one of the following two lines, and comment out the other
strDatabaseType =3D "Access"
'strDatabaseType =3D "MSDE"
'Now we use this selection to open the connection in the appropriate way
If strDatabaseType =3D "Access" Then
objConn.Open "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _
"Data Source=3DDRIVER=3D{Microsoft Access Driver
(*.mdb)};
DBQ=3D" & server.mappath("Investcalendar.mdb") & _
"Persist Security Info=3DFalse"
Else
objConn.Open "Provider=3DSQLOLEDB;Persist Security Info=3DFalse;" & _
"User ID=3Dsa;Initial Catalog=3DMovie;" & _
"Initial File Name=3DC:\MSSQL7\Data\Movie2000.mdf"
End If
objRS.Open "Movies", objConn, adOpenForwardOnly, adLockReadOnly,
adCmdTable
While Not objRS.EOF
Response.Write objRS("Title") & "<BR>"
objRS.MoveNext
Wend
objRS.Close
objConn.Close
Set objRS =3D Nothing
Set objConn =3D Nothing
%>
</BODY>
</HTML>
Thanks
cmedina@i...
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat
ego
ryid=3Drn_ebooks
Message #3 by Pappas Nikos <pappas@c...> on Sat, 01 Dec 2001 01:26:07 +0200
|
|
Hi
Every time I had this error was about the folders read and write permissions
where the database was located .
Try to ask your host about the folders permissions for IUSR.
Hope it will help
Nikos
PS
It is one of the very common subjects on this list.
At Friday30/11/2001, you wrote:
>Try with:
>
> objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "DBQ=" & server.mappath("Investcalendar.mdb") & _
> "; Persist Security Info=False"
>
>
>-----Original Message-----
>From: Cdeen1@h... [mailto:Cdeen1@h...]
>Sent: Friday, November 30, 2001 1:58 PM
>To: ASP Database Setup
>Subject: [asp_database_setup] Could not find installable ISAM
>
>Has anyine seen this error before? If so what the resolution?
>
>Microsoft JET Database Engine error '80004005'
>
>Could not find installable ISAM.
>
>/movie/connect.asp, line 25
>
>
>My Script:
><%Option Explicit%>
><% Dim adOpenForwardOnly, adLockReadOnly, adCmdTable adOpenForwardOnly = 0 adLockReadOnly = 1 adCmdTable = 2 Dim objConn,
objRS Set objConn = Server.CreateObject("ADODB.Connection") Set objRS = Server.CreateObject("ADODB.Recordset") Dim strDatabaseType
'Choose one of the following two lines, and comment out the other strDatabaseType = "Access" 'strDatabaseType = "MSDE" 'Now we use
this selection to open the connection in the appropriate way If strDatabaseType = "Access" Then objConn.Open
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
>"Data Source=DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("Investcalendar.mdb") & _
>"Persist Security Info=False" Else objConn.Open "Provider=SQLOLEDB;Persist Security Info=False;" & _
>"User ID=sa;Initial Catalog=Movie;" & _
>"Initial File Name=C:\MSSQL7\Data\Movie2000.mdf" End If objRS.Open "Movies", objConn, adOpenForwardOnly, adLockReadOnly,
adCmdTable While Not objRS.EOF Response.Write objRS("Title") & "
>" objRS.MoveNext Wend objRS.Close objConn.Close Set objRS = Nothing Set objConn = Nothing %>
>
>Thanks
>cmedina@i...
>$subst('Email.Unsub')
>
>Read the future with ebooks at B&N
>http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&catego
>ryid=rn_ebooks
>
>
>Read the future with ebooks at B&N
>http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid=rn_ebooks
|
|
|
View Cart
