Have been trying to access a stored proc on DB2,
Have created a DSN to connect to the host.
Have put the details of the DB2 host, username and password in a ini file.
Am accessing this proc from a vb program
Am able to test the connection successfully using IBM Db2 Client configuration assistant.
Was also able to run the vb program successfully on other systems,
But now am getting an error:
10/2/2006 1:40:33 PM -2147467259 Error in function getTrackingInfo - [IBM][CLI Driver][DB2]
SQL0969N There is no message text corresponding to SQL error "-725" in the message file
on this workstation. The error was returned from module "DSNXESSR" with original tokens
"CURRENT SQLID(ESSDB2B ) DB2BLOC". SQLSTATE=42721
eventhough I am able to test the connection to the host successfully,
Any idea why this could happen?
have narrowed this down to :
-725 THE SPECIAL REGISTER register AT LOCATION location WAS SUPPLIED AN
Explanation: DB2 received a SET statement with an invalid value. Valid
SETs might be allowed or retained. Further processing stops at the named
site until the SET statement is corrected.
System Action: All SQL statements at the named remote site are rejected
until the SET statement that was in error is corrected.
Programmer Response: The SET statement should be reissued with a valid
value. This situation can be corrected with a local SET statement or with
a DRDA SET statement executed at the remote site. Once the special
register has been supplied a valid value, the application can resume
but don't exactly know what to do with this info,
would reconfiguring the DSN help,
Is the version of DB2 client a problem?