VBScript, VBS Error

VBS Error

Author	Message
David Stacki #1 / 2	VBS Error I'm scripting a page that allows the user to write to a db the value for a search he/she is conducting. I keep getting this error... Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. /helpquery_test/helpdesk2.asp, line 56 Line 56 is this... objConn.Execute SQL Seems that the SQL statement is not correct....though it was working earlier in my testing stages. Any reason why it would all of the sudden give me this error.... TIA! David Stackis WebMaster
Sun, 08 Dec 2002 03:00:00 GMT

Shaw #2 / 2	VBS Error Post your db statements (Set lines connection & options lines, SQL String being passed, etc...) with the data types being obvious that you are passing... Shawn Quote: > I'm scripting a page that allows the user to write to a db the value for a > search he/she is conducting. > I keep getting this error... > Microsoft OLE DB Provider for ODBC Drivers error '80040e07' > [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria > expression. > /helpquery_test/helpdesk2.asp, line 56 > Line 56 is this... > objConn.Execute SQL > Seems that the SQL statement is not correct....though it was working earlier > in my testing stages. > Any reason why it would all of the sudden give me this error.... > TIA! > David Stackis > WebMaster
Sun, 08 Dec 2002 03:00:00 GMT

Page 1 of 1

[ 2 post ]