IIs Gremlins at night

[Brett_Tabke]

Do gremlins sneak into the IIS on the weekend?

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.

/nmz/story.asp, line 4

I've run into atleast 6 of those just today. I see them all the time and I wonder, what were they thinking of.

How do you guys hosted on IIS stomach it? More importantly, Why?

Help me to understand what the attraction is that would make you put up with it all?

[Chuma]

The error means there is a problem with one of the parameters being inserted into a table (I've come across this error before and fixed it by testing for illegal characters in input.)

Our company uses IIS so we can host the site ourselves and have easy access to upgrades.

For our company website, all pages that have forms submitted now insert the information from the forms into a database as well as sending an email (mainly as a backup.)

Thanks.

[webdevsf]

This error is not an IIS error. It is a SQL Server error caused by a bug in a SQL statement , typically caused by a junior programmer who is constructing sql statements dynamically, instead of using a stored procedure..

Somebody didn't debug their app, it's that simple. I guess if we all port our applications to apache/mysql, we won't have have any bugs in our programs anymore. :)