If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Getting SQLSTATE=42721 error--hlp plz

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-02-06, 22:48
Harry_Mave Harry_Mave is offline
Registered User
 
Join Date: Oct 2006
Posts: 1
Getting SQLSTATE=42721 error--hlp plz

Hi All,
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

-725 THE SPECIAL REGISTER register AT LOCATION location WAS SUPPLIED AN
INVALID VALUE

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
execution.

SQLSTATE: 42721



but don't exactly know what to do with this info,
would reconfiguring the DSN help,
Is the version of DB2 client a problem?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On