facebook google twitter rss Free Web Developer Tools Advanced Search Forum Programming Languages - More ColdFusion Development ODBC Error Code = 37000 (Syntax error or access violation) Thread: ODBC Error You may have to register before you can post: click the register link above to proceed. Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.
so the SQL to create the table is failing and the table is not created.Furthermore, dataserver creates objects related to the non-created table (stored procedures, indexes, sequences). Please sign in help Developers Croatian German Korean Italian Arabic Portuguese Romanian Japanese Spanish English ▼ tags users badges ALL UNANSWERED Ask Your Question 0 Base sql staus 37000 error code SQL = "INSERT INTO Healthcare_Catalog( Program_Name, Program_Web, Program_Description, Provider_Name_Short, School, Location_City, Location_State, Program_Notes, Program_Contact, Contact_Email, Contact_Phone, Distance, Degree_Level, Attendance_Options, Length_of_Program, Length_of_Program_Years, Occupational_Information, Rural_Opportunities, Admission_Prerequisites, Rural, Focus_Program) VALUES ( 'testone', '', '', Resolution This operation is performed at the driver level.
Information for REO1 --->
|*First Name:||*Last Name:|
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (92:1) to (92:74). Results 1 to 3 of 3 Thread: Help with ODBC Error Code = 37000 (Syntax error or access violation) Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Thanks in advance for your assistance.