Welcome to WebmasterWorld Guest from 54.158.51.150

Forum Moderators: incrediBILL & lawman

Message Too Old, No Replies

IIs Gremlins at night

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

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



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)

10+ Year Member



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.

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

10+ Year Member



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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month