Error - SQL state S1010 Function sequence error


 Product(s):Bentley Raceway and Cable Management
 Version(s):08.11.07.xx
 Environment:N/A
 Area:Installation_Configuration
 Subarea:N/A

Error or Warning Message

An error message that includes the following text occurs frequently when updating the database:

SQL state: S1010
SQL Error: [Microsoft][ODBC Driver Manager] Function sequence error

How to Avoid

Include "MARS_Connection=yes" in the value for BRCM_DB_CONNECTSTRING.

  1. Open the .PCF file for a problem project in Notepad
  2. Append ";MARS_Connection=yes" to the BRCM_DB_CONNECTSTRING line.  For example:

    BRCM_DB_CONNECTSTRING=DSN=BRCMUSER;UID=BRCMUser;PWD=brcm;MARS_Connection=yes

 Original Author:Matt_P