Welcome to WebmasterWorld Guest from

Forum Moderators: incrediBILL & lawman

Message Too Old, No Replies

IIs Gremlins at night

9:37 pm on Feb 9, 2003 (gmt 0)

Administrator from US 

WebmasterWorld Administrator brett_tabke is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Sept 21, 1999
votes: 13

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?

10:54 pm on Feb 9, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 10, 2002
votes: 0

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.)


12:25 am on Feb 10, 2003 (gmt 0)

Full Member

10+ Year Member

joined:Dec 6, 2002
votes: 0

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. :)