Can't insert record into SQL server express from ADO.NET inside IIS

[Lei Yang]

Hi, All:

I am trying to insert records into SQL server express 2005 from ADO.NET
(sql client) inside IIS. I am able to do every things correctly from visual
studio 2005 with help of asp.net development server. However, when I publish
code into IIS at localhost machine, code does nothing without any error
message if I shown down asp.net development server.

What a trick do I need to know???????


Thanks

 

[Lei Yang]

Hi, All:

I am trying to insert records into SQL server express 2005 from
ADO.NET (sql client) inside IIS. I am able to do every things correctly from
visual studio 2005 with help of asp.net development server. However, when I
publish code into IIS at localhost machine, code does nothing without any
error message if I shut down asp.net development server.

What a trick do I need to know???????


Thanks

 

[Lei Yang]

Hi, Eric:

Thanks a lot!

It still does not work yet without any error message. I am really lost with
this strange error! Here is my config file:

<?xml version="1.0"?>

<configuration>


<appSettings/>

<connectionStrings/>


<system.web>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

-->

<compilation debug="true" />

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

<authentication mode="None" />

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

-->

<customErrors mode="RemoteOnly">

<error statusCode="403" redirect="NoAccess.htm" />

<error statusCode="404" redirect="FileNotFound.htm" />

</customErrors>

</system.web>

</configuration>



If I start asp.net development server, it works correctly with IIS. My
machine is XP sp2.



Note that I don't care for security as long as I can get it to work with
IIS, ASP.NET2 and SQL server express 2005. It is a simple internal project.



Waiting for your further guide.



Thanks a lot again!

 

[Lei Yang]

Hi, Eric:

No error message on web page! If there is an error on page, I would be able
to fix the problem by myself.

I don't know why. If I start asp.net development server, it works fine. I
have some strange security setting problems? I can not access database from
other LAN machines although I can retrieve asp.net 2 web pages.

Regards,

 

[Lei Yang]

Hi, All:

I found the cause of the error! Thanks to Eric.