Re: Why can"t I open?

On Feb 23, 5:07 pm, "Rolf Rosenquist" wrote:
> 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

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
> 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

Re: Why can"t I open?

Rolf Rosenquist wrote:
> 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
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
--
Microsoft 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.

Why 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

Re: Why can"t I open?

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


"jweiss" skrev i meddelandet
news:1172265993.682929.61750@8g2000cwh.googlegroups.com...
>
> Can you provide an error? Maybe it's a permission thing?
>

Re: Why can"t I open?

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



"Bob Barrows [MVP]" skrev i meddelandet
news:uslNeS5VHHA.3980@TK2MSFTNGP02.phx.gbl...
> > 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
> --
> Microsoft MVP -- ASP/ASP.NET
>