Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Could not find installable ISAM Error

1 view
Skip to first unread message

UZI DOES IT

unread,
Oct 16, 2002, 8:41:35 PM10/16/02
to
The script that I'm running works just fine on my local machine. But when I
try to upload it to the server and run it there I get the error below.
Should I try DSN-less connection. I did a search on Google and it seems that
a lot of people had the same problem but I am yet to find
a solution that works. Opening asp file in general works just fine on the
remote machine. So I think the error is somewhere with the connection
object.
------------------
Here us the Error
------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not find installable ISAM.

/script_folder/script.asp, line x


--------------------------
Here is the gist of my script:
--------------------------

<%@ Language = "VBScript"%>
<%
'Declare all local variables
dim conn
dim strsql
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Activation_Form"
strsql = ""

if (Request.Form("hiddenField")="new_file") then 'Insert New Form into
DataBase
'build the sql statement based on the input from the form
strsql = "input from form"

'Use the execute method of the connection object then insert the record
conn.execute(strSQL)
Response.Write("<html><title>ParishPay Activation Form</title><body><h4>Your
record has been added</h4></body></html>")

elseif (Request.Form("hiddenField")="old_file")then 'Update a record in the
DataBase
strsql = "input from form"

conn.Execute(strsql)
Response.Write("<html><title>ParishPay Update Form</title><body><h4>Your
record has been Updated</h4></body></html>")
end If

conn.close
set conn = nothing
%>


Tom Kaminski [MVP]

unread,
Oct 17, 2002, 8:57:40 AM10/17/02
to
"UZI DOES IT" <u...@does.it> wrote in message
news:UInr9.15227$L42...@news4.srv.hcvlny.cv.net...

> The script that I'm running works just fine on my local machine. But when
I
> try to upload it to the server and run it there I get the error below.
> Should I try DSN-less connection. I did a search on Google and it seems
that
> a lot of people had the same problem but I am yet to find
> a solution that works. Opening asp file in general works just fine on the
> remote machine. So I think the error is somewhere with the connection
> object.
> ------------------
> Here us the Error
> ------------------
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Could not find installable ISAM.

http://www.aspfaq.com/show.asp?id=2259


tristian o'brien

unread,
Oct 17, 2002, 11:45:04 AM10/17/02
to
had this problem before,

have you tried

conn.Open "Activation_Form", dbuser, dbpass

even if there is no username or password security present
can cause massive hair loss this one...

tris


0 new messages