Microsoft JET Database Engine error

I'm having some problems getting my shopping cart to work on a windows 2003 server. When I go and add something to the cart I get this error.

Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
/cgi-bin/shop1.asp, line 137

Now I did some digging round and found that this is a problem with windows 2003 server. So i got in touch with my hosting co and set them the info on what needs to be done on there end. as per this link

http://support.salescart.com/kb/KB-details.asp?key=5338

They set me this info,

Well, if you are using MS access database file (*.mdb ) uploaded to the root location, then in that case , the mdb file should be set with "modify" permission. Since the error is related to "Could not find installable ISAM." , you need to refer to the documentation of your shopping cart to make sure that the installation is complete. Also if you are using OLEDB for connection to your MS Access database , please make sure that the provider used in the connection string is as follows:

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.mappath(DATABASEPATH) & ";Persist Security Info=False"
objConn.Open
Set Session("mdbDefined") = objConn


Now HTML is not my strong point, and I'm not sure were I should put this. Now when I asked them were I should put this code they said give us a day or 2 to look into this. After 3 days I got a message.

Unfortunately, our system administrators have informed us that we are not setting up custom DSN's on our windows servers at present time. Please use one of the following resources to set up a DNS-less connection to your database:

So what do I want to do? Add the code and were to ? I take it to the globle.asa file and were in the file? And or try to setup a DNS-less connection to my database.

Now I had this website and shopping cart working on a different server about a year ago. But I think they were running windows 2000 server, not sure. But this problem is driving me nuts.


lw

Ok what do i need to do to the global.asa file? Do i need to add this code

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.mappath(DATABASEPATH) & ";Persist Security Info=False"
objConn.Open
Set Session("mdbDefined") = objConn


to the file? and were?   Or is there something alse I need to do?

lw

progressive1 wrote: did you ever resolve this issue, I am having the same problem. Mike

Yes and No   I could not get any info on were to put the new code. I ended going back to a webhost that I started with and was running win2003 server. I talked to the webmaster and he made a change to my control panel so all i had to do was tell it what ODBC drivers i needed and the path to the DB. And that fixed the problem. I still have no idea how to fix this by HTML code.


lw

Will Sani wrote: Lonewolf wrote: progressive1 wrote: did you ever resolve this issue, I am having the same problem. Mike Yes and No   I could not get any info on were to put the new code. I ended going back to a webhost that I started with and was running win2003 server. I talked to the webmaster and he made a change to my control panel so all i had to do was tell it what ODBC drivers i needed and the path to the DB. And that fixed the problem. I still have no idea how to fix this by HTML code. lw So you have the ODBC DSN all setup?

Yes I do. But it was done by the webmaster adding a ODBC control page that just asked for the info and it did all the work. I still do not know how to add the code to the globle.asa file as in were and what info to add and how to type it.


lw