Re: ODBC error 'Function Sequence Error' in SQR

["Walcker, Paul" <pwalcker@ISD.CO.SAN-BERNARDINO.CA.US>]

You may want to pick up a tool from Microsoft call ODBC Spy 32
(ODBCSP32.EXE).  This tool allows you to capture all of the ODBC API
calls issued against a specific data source.  With this tool you should
be able to determine exactly where your error messages are being
generated, then move backwards to determine which API statement started
the problem.  I haven't found a place to download it from, but I know it
is shipped with some versions of Visual Basic 5.0 (like the Enterprise
Edition).  Quite a handy tool to have on around!

Paul

>-----Original Message-----
>From:  Parijat Sahai [SMTP:parijatsahai@HOTMAIL.COM]
>Sent:  Tuesday, July 07, 1998 3:21 PM
>To:    Multiple recipients of list SQR-USERS
>Subject:       ODBC error 'Function Sequence Error' in SQR
>
>Hi,
>
>I'm using SQR v3.0 in PeopleSoft v6 with MS SQLServer as the back-end.
>Every now and then, I get the ODBC error '[Microsoft][ODBC SQL Server
>Driver]Function sequence error'. It stays for a long time and then stops
>appearing all of a sudden (I'm not aware of any activity at the database
>end by DBA or anybody, for that matter). This error comes in
>begin-select statements or during begin-sql (UPDATE) statement.
>
>Can anyone diagnose the problem and/or suggest a possible solution?
>
>Parijat
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com