I upgrade my db2 8.1 from fixpak 7 to fixpak 11, it cause a serious
problem:
in db2 8.1 with fixkpak 7, i use microsoft oledb for odbc + ibm db2
runtime client to access the database. so in my delphi program, i can
use the following code:
(we declare query1 is TADOQuery):
query1.Insert;
query1.FieldByName('user_name').AsString = 'xxxx';
query1.Post;
=================
the above code can be executed successfully.
but when i upgrade to fixpak 11, the above code be executed failed, the
error is :
[IBM][CLI Driver] CLI0125E function sequence error. SQLSTATE=S1010
petr.kralik@atlas.cz - 23 Feb 2006 10:02 GMT
Please try following:
db2 CONNECT TO <dbname>
db2 BIND $DB2DIR\BND\@db2ubind.lst GRANT PUBLIC ACTION ADD
db2 BIND $DB2DIR\BND\db2schema.bnd BLOCKING ALL GRANT PUBLIC sqlerror
continue
db2 terminate
ronyfly@gmail.com - 24 Feb 2006 09:16 GMT
thank you very much! petr.kralik@atlas.cz .
By your detail help, now i can execute the above source code
successfully.
Gert van der Kooij - 23 Feb 2006 10:11 GMT
> I upgrade my db2 8.1 from fixpak 7 to fixpak 11, it cause a serious
> problem:
[quoted text clipped - 15 lines]
>
> [IBM][CLI Driver] CLI0125E function sequence error. SQLSTATE=S1010
Did you rebind the system packages and ran db2updv8 after installing
the PTF?
ronyfly@gmail.com - 24 Feb 2006 09:20 GMT
ok. thanks! Gert van der Kooij .
I rebind the db2schema.bnd.
but no run db2updv8.
and my program can run normally.