New ASP Site in IIS Crashes

I developed an application in asp on a test server. This application queries
an SQL DB within the same network.

When finished, I created a new web site in my IIS. I then copied all of my
asp pages into the new folder where the new site lives. When I open my
browser and surf to the new site my ASP pages load but all of the SQL queries
in my ASP/VBscreipt code do NOT work. I get Type MisMatch errors. I have
not changed the code at all.

Is there something else that needs to be setup to activate VBScript or ASP
on a new web site? Very strange.

Please let me know your thoughts.

Re: New ASP Site in IIS Crashes

you shouldn't have to enable anything extra (aside from on IIS6, but you'd
be getting a different error). Give us some specifics and we'll see what we
can come up with.


--
Jason Brown
Microsoft GTSC, IIS

This posting is provided "AS IS" with no warranties, and confers no rights.


"TR" wrote in message
news:FE49D205-2148-41D7-8DEB-9F0E33299922@microsoft.com...
>I developed an application in asp on a test server. This application
>queries
> an SQL DB within the same network.
>
> When finished, I created a new web site in my IIS. I then copied all of
> my
> asp pages into the new folder where the new site lives. When I open my
> browser and surf to the new site my ASP pages load but all of the SQL
> queries
> in my ASP/VBscreipt code do NOT work. I get Type MisMatch errors. I have
> not changed the code at all.
>
> Is there something else that needs to be setup to activate VBScript or ASP
> on a new web site? Very strange.
>
> Please let me know your thoughts.

Re: New ASP Site in IIS Crashes

Give the exact error and show the block of code that it occurs in (indicate
the actual line).

At a guess I would say that you are using the ADO constants in your
conn.execute calls and they are not defined properly in the new site (is it
on the same machine?).

--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com


"TR" wrote in message
news:FE49D205-2148-41D7-8DEB-9F0E33299922@microsoft.com...
>I developed an application in asp on a test server. This application
>queries
> an SQL DB within the same network.
>
> When finished, I created a new web site in my IIS. I then copied all of
> my
> asp pages into the new folder where the new site lives. When I open my
> browser and surf to the new site my ASP pages load but all of the SQL
> queries
> in my ASP/VBscreipt code do NOT work. I get Type MisMatch errors. I have
> not changed the code at all.
>
> Is there something else that needs to be setup to activate VBScript or ASP
> on a new web site? Very strange.
>
> Please let me know your thoughts.

Re: New ASP Site in IIS Crashes

On Thu, 24 Mar 2005 15:03:02 -0800, "TR"
wrote:

>I developed an application in asp on a test server. This application queries
>an SQL DB within the same network.
>
>When finished, I created a new web site in my IIS. I then copied all of my
>asp pages into the new folder where the new site lives. When I open my
>browser and surf to the new site my ASP pages load but all of the SQL queries
>in my ASP/VBscreipt code do NOT work. I get Type MisMatch errors. I have
>not changed the code at all.
>
>Is there something else that needs to be setup to activate VBScript or ASP
>on a new web site? Very strange.
>
>Please let me know your thoughts.

Post the full error messages. And fix the type mismatches.

Jeff