FrontPage_ConvertFromODBC

C

Craig Det

My ISP has changed their server to a w2k2003. He moved my site to the new
server. Now I get an error

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name
or ordinal.

on most of the pages.
Also every time you press a submit button on a page it opens a new window.

I found out that the global.asa file has been modified and a new function
has been added

FrontPage_ConvertFromODBC '==FrontPage Generated==

If I remove this line the hold site works ok. If I leave it, it doesn't.

I saw a forum that said that the new IIS6 and w2k3 has been changed and that
the new ver will not except Query's names with spaces. My Qrys don't have
spaces and it is still not working

here is an example of a complex one
fp_sQry="SELECT Order_Process_tbl.Order_Tracking_id, * FROM
(Order_Process_tbl INNER JOIN Pickup_Location_tbl ON
Order_Process_tbl.Pickup_id = Pickup_Location_tbl.Pickup_id) INNER JOIN
Order_Status_Tbl ON Order_Process_tbl.Status_id = Order_Status_Tbl.Status_id
WHERE (((Order_Process_tbl.Order_Tracking_id)=::Order_Tracking_id::));"

If i remove the Line from the global.asa file it works, but every time I
recalculate Hyperlinks it returns. How do we remove this?

Any Help would be appreciated!

Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top