On Feb 23, 5:07 pm, "Rolf Rosenquist" <r...@nomail.com> 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

> 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

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

>
> Can you provide an error? Maybe it's a permission thing?
>

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