Works on local machine but not on server

[Freddy]

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?

 

[MD Websunlimited]

What is the error message, Freddy? May we have the URL?


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
Wish you could calculate form field totals? Well, you can with Form Calculator
http://www.websunlimited.com/order/Product/FormCalc/formcalc.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible