Connecting sql 2000 sp3 with asp

[Wonder]

I created a new SQL database using SQL 2000 SP3 on a Windows 2003
server. Now when my wed publisher changes his codes in ASP to point to
my new server and SQL database we are getting the message this page can
not be displayed when clicking on the web link. The old SQL database
was created with SQL 2000 on a Windows 2000 server. Below you will find
the ASP code that we are using. Please Help me!

<!--Open Connection to SQL Database-->
<%'CREATE/OPEN ADO CONNECTION OBJECT
Dim objConnect, oSurvey
Set objConnect = Server.CreateObject("ADODB.Connection")
oSurvey = "driver={SQL Server};server=SPD-HEAT-01;database=Heat8;" &
_
"uid=johndoe;pwd=johndoe"
objConnect.Open oSurvey,"",""%>

[richarddageek]

Try enabling server side debugging on the iis server, and then goto the
site again, this might give you a better idea of exactly what the
connection error is.

Its also possible the new db server has a different driver string for
the sql server.