 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ASP / Database Access / February 2007Why can't I open?
I am not able to open the table with these lines on my normal webhotel. But it works fine on my local computer. BoknID = Request.Querystring("boknid") Set rsBokn = Server.CreateObject("ADODB.Recordset") sqlBokn = ("SELECT * FROM Bokning WHERE BoknID = " & BoknID ) rsBokn.Open sqlBokn, ObjConn, adLockOptimistic, adCmdTable On the webhotel it says that the page cannot be shown when trying to run the last line. The table is there, there is the same data in it as in my local comp, I have even copied the table and the same asp pages to another webhotel and there it works. To complicate it even more, these lines in other programs with other tables work since 5 years on the same first troublesome webhotel. Can anyone spread som light? I am in total darkness here. / Rolf > I am not able to open the table with these lines on my normal webhotel. But > it works fine on my local computer. [quoted text clipped - 5 lines] > > On the webhotel it says that the page cannot be shown Can you provide an error? Maybe it's a permission thing? when trying to run the > last line. The table is there, there is the same data in it as in my local > comp, I have even copied the table and the same asp pages to another [quoted text clipped - 4 lines] > Can anyone spread som light? I am in total darkness here. > / Rolf Yes I did make a division by 0 and got the same 'cannot-show-page' message. When I did it on my local I got the info that I was trying to divide by 0. / Rolf > Can you provide an error? Maybe it's a permission thing? > I am not able to open the table with these lines on my normal > webhotel. But it works fine on my local computer. [quoted text clipped - 13 lines] > Can anyone spread som light? I am in total darkness here. > / Rolf So are we. You need to provide the actual error. If you are getting the uninformative 500 page, see this: http://www.aspfaq.com/show.asp?id=2109  SignatureMicrosoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. Thanks very much. This did the trick so I could trace it. Then I saw that it said that there was no table with that name. Actually there was and I had named it 'bokning', but in the script I had named it 'Bokning' with starting versal. On my local machine it obviously did not matter, but up on the server it did. I now I have a vague remembering that I have had that type of error several years back. Now that I am older, it seems to have faded a bit. Good that you had your intact. :-) Thanks / Rolf > > Can anyone spread som light? I am in total darkness here. > > / Rolf > So are we. You need to provide the actual error. If you are getting the > uninformative 500 page, see this: > > http://www.aspfaq.com/show.asp?id=2109 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.