Code works locally but not on webserver

[freddytdt]

Hi

I am relatively new to ASP coding, but I'm an experienced SQL coder. My problem is that I've designed a website which connects to a SQL 2000 server via the MS Frontpage 2002 webbot.

Running on my local machine (XP running IIS 5.1) I have no problems with accessing the database via the Frontpage generated ASP pages. Being happy that everything is okay, I have asked the ISP to restore a backup of my database onto their SQL 2000 server using the same database name and the same DSN. I have to use FTP to publish the pages as Frontpage won't connect to their webserver. So I proceded to FTP the individual pages (as well as the global.asa file) across to the ISP.

Lo and behold, when I try and access the ASP pages I get an HTTP 500 - Internal Server Error. I do know however that it is the database connection, as a standard ASP page (just running <%=date %> works just fine. Any ideas as to how I can sort this out?

 

[CoreyBryant]

When you say the web-bot, that usually requires FP extensions. If the hosting company does not support FP extensions - there is nothing you can do except either hand-code the ASP page or change hosting companies.

__________________________
Corey

http://www.merchantaccounts4less.com/