Installable ISAM
i m getting the following errror while tryig to connect to the excel file.
View Repliesi m getting the following errror while tryig to connect to the excel file.
View RepliesI am working on a free hosting site that supports ASP. Uploaded a Microsoft Access db(version 2000) and configured using dsn-less connection (a must for the site) but cannot open db getting the error: cannot find installable ISAM. Here is my code. Is the problem with my code, a problem with the access db driver on my computer, or a problem with the servers drivers?
<%Dim conn, rs
set con = server.createobject("ADODB.connection")
set rs = server.createobject("ADODB.recordset")
dsnname = "driver=microsoft access driver (*.mdb);dbq="
dsnname = dsnname & server.mappath ("/database/promotions.mdb")
conn.open dsnname
sql = "SELECT * FROM Clients"
rs.open sql,conn,3,3
rs.movefirst
do until rs.eof
%>
I am trying to connect to my database on a server, but am getting the following error: Could not find installable ISAM.
What is the problem here?
Code: ....
I am encountering the same old error,
"Microsoft JET Database Engine (0x80004005) Could not find installable ISAM."
when i try to open an Access file and export the data into it from a table.
Have updated MDAC2.7 and even then its not working. My code looks like
Set tdf = Server.CreateObject("ADOX.Table")
Set cat = Server.CreateObject("ADOX.Catalog")
tdf.Name = ltablename
cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & lFilepath & ";Jet OLEDB:Engine Type=4;"
What should be done.Provide some solutions.
we are using a flat file database (ISAM) which i have been asked to write to a text file. I can write to a text file from a relational database like Access/SQL using FSO, but my problem now is to export this our data in flat file format to access database so that i can write it to a text file. Can anybody help with the script that will export this data to access?
View Replies View Related