Tags: clear, database, db2, driver, encountered, error, function, manager, microsoftodbc, mysql, oracle, pls, postings, powerbuilder, sequence, similar, sql, sqlstates1010, updatebl, updateblob

sqlstate=S1010 [Microsoft][ODBC Driver Manager] Function sequence error updatebl

On Database » DB2

786 words with 2 Comments; publish: Wed, 05 Dec 2007 07:08:00 GMT; (25046.88, « »)

Hi, i encountered this error when trying to updateblob to db2 using powerbuilder 6.5. I've seen similar postings but never a clear answer. Pls help but pls do not suggest using a third party ODBC driver (unless it is free and not an evaluation copy). Thanks!

All Comments

Leave a comment...

  • 2 Comments
    • I would suggest you to take a cli trace to see why it happens ...

      'tip of the month' section in www.db2click.com has info on enabling CLI trace

      #1; Tue, 11 Dec 2007 17:58:00 GMT
    • I would install the DB2 client and catalog the database with IBM ODBC driver using the Client Configuration Assistant. I am using PowerDesigner (same company as PowerBuilder) and it works fine on a remote database cataloged with IBM ODBC driver. You can test the IBM ODBC connection using the Client Configuration Assistant before you try it with PowerBuilder.
      #2; Tue, 11 Dec 2007 17:59:00 GMT