Trouble in Web Database

[Abhas]

I have a website written in ASP.
I am facing a problem, that i am unable to write anything to the database (I am using MS Access database). I can easily read from the the db without any problems.

When i submit a form, which needs to be stored in the db, i get an error stating that database or object is write protected.
It works perfectly fine on localhost...

i am using this particular code to connect to the db in global.asa file:

Application("connStr") = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("cart.mdb") & ";User ID=admin;password=;"

I have also tried this method :

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("\somepath\dbname.mdb") & ";User Id=admin;Password=pass;"

Can anyone plz help me...

PS : another thing i wanted to inform is, that the submit form button does not work in firefox... nothing happens when it is clicked...

 

[Abhas]

anybody???

 

[Brett_Lee]

Hmm i dont know asp. I know a tiny bit of php but i wont be able to help you

have you tried posting on a computer forum, try www.neowin.net and post in the webdesigners forum

 

[Abhas]

thanks for the suggestion, i will certainly try to get help from other forums...

 

[sohum]

Any luck? I've been working with PHP and JSP but not quite ASP. I do have an ASP book in front of me right now, but I will only look at it sometime tomorrow, if you still haven't figured it out.

 

[Abhas]

no luck mate, at the neowin forum also, there is not much help...
most of the threads are php, only a few in ASP, and those with little replies...
one person told me it might be due to the web hosting company, another says its probably coz of interactive user control... i dont know what it is...

if u can help sohum, it wil be really appreciated...

if u want to see my site, u can check my profile...

the problem occurs after trying to buy any item from the shopping cart, when the user fills in an order-form...

it is at that particular page, when i click on submit, that i get this error message.
also, the submit button doesn't work in firefox

 

[Brett_Lee]

Here is another one i used to go on which i found helpful

http://www.codingforums.com/

 

[Abhas]

thanks, i'll try my luck on this one as well...

 

[sohum]

With regds to the submit button, I looked at your source and it seems that the document.whatever.* may not work with Firefox. Try document.getElementById(formName) but you will also have to give your form an ID for that to work.

Also, it may just be that you have Jscript disabled. Let me know if the website is live because otherwise I can put in some dummy orders and try troubleshooting it best as I can. As it happens, I don't want to give away Rs. 6000 now.

Edit: I may have misread the thread though:
http://www.webmaster-talk.com/javascript-forum/45517-firefox-javascript-problem-2.html#post389299

Also, put some debug code into the verify() function because I'm unsure how far it progresses down it.

 

[Abhas]

the website is live, but dont worry, i have the control to it, so u wont need to spend 6000 bucks when u click on the submit

You can safely "buy" as much as you want, no issues.

I will try the document.getelementbyid method...

Hey 1 thing i was confused about is, do i have to use this :
document.getElementById(formName) in every place where i was using the earlier code i.e (eg.) document.all.Details.IType.value

i dont know too much ASP programming, and this seems a bit confusing to me.

i asked because this is used everywhere in the site, (in almost all the pages) and they all load up fine in firefox.

only submit button was the problem in firefox...

 

[sohum]

the website is live, but dont worry, i have the control to it, so u wont need to spend 6000 bucks when u click on the submit

You can safely "buy" as much as you want, no issues.

I will try the document.getelementbyid method...

Hey 1 thing i was confused about is, do i have to use this :
document.getElementById(formName) in every place where i was using the earlier code i.e (eg.) document.all.Details.IType.value

i dont know too much ASP programming, and this seems a bit confusing to me.

i asked because this is used everywhere in the site, (in almost all the pages) and they all load up fine in firefox.

only submit button was the problem in firefox...

I'm not sure. This isn't an ASP issue though--it's a Javascript issue. Firefox always has teething problems with Javascript, especially that written for IE because IE is far less secure.

Unfortunately I'm not that familiar with Javascript. However, Javascript is the web's premier scripting language so you should be able to find plenty of resources. Try seeing if the submit button works in a plain form with a trivial verify() function.

Maybe it is something else in the verify function that is causing it to hang? Try putting a few alerts in because I don't think there is any other way to debug Javascript.

 

[Abhas]

hmm.. nice tip, i'll try this out...
the problem is, sometimes, the site doesnt work in firefox in localhost...

we seem to be slipping away from the main problem though...
the submit form button leads to an error saying that the database or object is read-only... this happens in internet explorer...

 

[sohum]

hmm.. nice tip, i'll try this out...
the problem is, sometimes, the site doesnt work in firefox in localhost...

we seem to be slipping away from the main problem though...
the submit form button leads to an error saying that the database or object is read-only... this happens in internet explorer...

Hmm, looks like your server is a little iffy (IIS?). Also, database reading works on your development server (localhost), you said? I don't see why you can read but not write unless your dbuser doesn't have that permission. Then again, I don't really know the interfacing between ASP and Access. I'll check that book out tomorrow.