RE: ODBC Error Code = 37000
man, i had that same error about 3-4 weeks ago... i was playing with a small access database and then one day every insert to one table came back with this error... i couldn't figure it out, i built a new table and transferred the data and relationships over and whola! it worked... i still have no clue except somehow it was a problem with accessing that one specific table.. Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader > -Original Message- > From: Nick Call [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 16, 2001 1:23 PM > To: CF-Talk > Subject: ODBC Error Code = 37000 > > > Anyone seen this before? I have one site user who gets this > error any time > he visits on particular page. He is the only guy in a year > of being live > who has had this problem. > > Thanks in advances for your expertise. > > Nick Call > [EMAIL PROTECTED] > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
what is the code for the query? I'd guess that it's either a Where problem or a variable reference problem. Hatton -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:35 PM To: CF-Talk Subject: ODBC Error Code = 37000 UGH! I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client variable. Anyone seen this before? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '55'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
No query at all, it's a client variable going to a database. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:56 PM To: CF-Talk Subject: RE: ODBC Error Code = 37000 UGH! what is the code for the query? I'd guess that it's either a Where problem or a variable reference problem. Hatton -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:35 PM To: CF-Talk Subject: ODBC Error Code = 37000 UGH! I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client variable. Anyone seen this before? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '55'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!
okay, there's got to be some SQL going from CF to the database driver... either an insert into or an update. Check to make sure that the variable you're updating in the database is the propper type for what CF is trying to put there. HTH Hatton -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:51 PM To: CF-Talk Subject: RE: ODBC Error Code = 37000 UGH! No query at all, it's a client variable going to a database. -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:56 PM To: CF-Talk Subject: RE: ODBC Error Code = 37000 UGH! what is the code for the query? I'd guess that it's either a Where problem or a variable reference problem. Hatton -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 10:35 PM To: CF-Talk Subject: ODBC Error Code = 37000 UGH! I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client variable. Anyone seen this before? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '55'. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists