I have been using cold Fusion 3.X for years and just upgraded to a server with the latest version. All of my queries worked fine on the old version but now I get this error message on my insert. Is there something I need to do with the code or is it in the server. Thanks for any assistance.
Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. The Error Occurred in D:\wwwroot\Kraft\Qtr Report 2003\InsertQR2003.cfm: line 14 12 : <body bgcolor="FFFFFF"> 13 : <img src="../images2/banner.JPG" width="700" height="114"> 14 : <CFINSERT DATASOURCE="QtrReport2003" TableName="2003QR"> 15 : 16 : <CFQUERY NAME="GetEnteredRecordID" DATASOURCE="QtrReport2003"> ---------------------------------------------------------------------------- ---- SQL insert into 2003QR (NAME,PASSWORD) values ( (param 1) , (param 2) ) DATASOURCE QtrReport2003 VENDORERRORCODE -3035 SQLSTATE HY000 It also will run the update pages it gives the following error message. Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. The Error Occurred in D:\wwwroot\Kraft\Qtr Report 2003\UpdateQR2003.cfm: line 14 12 : <body bgcolor="FFFFFF"> 13 : <img src="../images2/banner.JPG" width="700" height="114"> 14 : <CFUpdate DATASOURCE="QtrReport2003" TableName="2003QR"> 15 : 16 : <CFQUERY NAME="GetUpdate" DATASOURCE="QtrReport2003"> ---------------------------------------------------------------------------- ---- SQL update 2003QR set ACTUALHOURS1= (param 1) ,BRANDING1= (param 2) ,NOTINBUS1= (param DATASOURCE QtrReport2003 VENDORERRORCODE -3035 SQLSTATE HY000 Jim Kraft, Director Region 8 SBDC 33 South 3rd St. Richmond, IN 47374 765-962-2887 fax 765-966-0882 [EMAIL PROTECTED] http://www.sbdc1.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
