Hello Curtis, I know the merant drivers do not cause this problems, but I want to keep this solution as a last possible fix.
I noticed the problems are related to CF, because the same query in SQL+ does not give the error. I found a dirty roundabout for the problem, and that is to verify the datasource as soon as the problem occurs. I hope Macromedia or anybody in the list can come with a solution so I can stay using the Oracle ODBC driver. Cheers, Johan -----Original Message----- From: Curtis Traverse [mailto:[EMAIL PROTECTED]] Sent: vrijdag 12 april 2002 14:28 To: Spectra-Talk Subject: Re: Help on S1010 Function Sequence error Hey Johan, In our current application we had the exact same problem using Oracle 8.16. Our fix for it was the use the Merant Oracle 8 drive that comes with Coldfusion. The only catch to this fix is that you cannot use this driver for any of the security or authentication datasources. Once we started using the Merant drive this problem no longer occurred. Hope this helps. = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Curtis Traverse ----- Original Message ----- From: "Johan Coens" <[EMAIL PROTECTED]> To: "Spectra-Talk" <[EMAIL PROTECTED]> Sent: Friday, April 12, 2002 3:05 AM Subject: Help on S1010 Function Sequence error > Hello, > > We are running Spectra 1.5.1 with the latest patches on a win2000 machine > with cf5.0. The database server is Oracle 8.1.6 on a Sun solaris machine. I > connect through a Oracle ODBC driver version 8.1.6.6.0. When editing a > container the following error occurs after a random period of time (1 hour - > 2 days): > > > ODBC Error Code = S1010 (Function sequence error) > [Microsoft][ODBC Driver Manager] Function sequence error > SQL = "delete from sharedobjectsynchronization where originalobjectid = ?" > Query Parameter Value(s) - > Parameter #1 = 418B359E-CC17-4FBC-8FA68A828AA72A80 > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (64:1) to (64:67) in the template > file D:\PROGRAM > FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDDELETE.CFM. > > The error occurred while processing an element with a general identifier of > (CFRETHROW), occupying document position (123:3) to (123:13) in the template > file D:\PROGRAM > FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\CFA_RECORDDELETE.CFM. > > > The only solution seems to restart the cf server, after the reboot the > application is running well. > > Has anyone got a solution for this > > Johan Coens > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
