I'm posting this response in both of your question threads so that all can see...

Because you are new to PowerBuilder, I suggest you consider investing a little time and work through all of the 24 units of the free, on-line PowerBuilder Fundamentals course available at the Appeon-U section of the Appeon Community website:

   https://www.appeon.com/appeon-u/pb

Apologies i will send clear explanation next time thanks for the advice

1) Show us the code where the error is occurring
2) Show us the error msg
3) Tell us what version of PB you are using AND the platform you are on (i.e Windows 10, 64 bit)

4) Run your code in the debugger with a breakpoint JUST before the failure.
5) When you get to the breakpoint, show us the value of the variable(s) that are failing by finding them in the bottom pane of the Debugger. They may be local, instance, or global variables.

With THAT information, someone MIGHT be able to help you.


And please..... don't post things like "someone respond". No one here works for you. We are all volunteers and posts like that will get you deliberately ignored.

someone respond

Please let us know how to resolve the issue.
// Profile PRC SQL
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = <********>
SQLCA.ServerName = "***************"
SQLCA.LogId = "prcmsdev"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Provider='SQLNCLI11',Database='PrcDb'"

[PRCLUATMSSQL1_DS]
;Autocommit defaults to false if no entry here - can be overridden in users registry
;DBMS = "SNC SQL Native Client(OLE DB)"
;DBMS = "OLE Microsoft OLE DB"
;DBMS = "MSOLEDBSQL SQL Server"
DBMS = "ODBC"
LogPass = <********>
ServerName = "tcp:mss-nm-7057-aol.nam.nsroot.net,2431"
LogId = "*******"
AutoCommit = False
;DBParm = "Database='PrcDb',Provider='SQLNCLI11'"
;Name=UATMSSQLL
;AutoCommit=true
;DataBase=PrcDb
;DBMS=SNC
;Driver={ODBC Driver 17 for SQL Server}
;Driver=SQL_NO_PROMPT
;SERVER=mss-nm-7057-aol.nam.nsroot.net,2431
;ServerName=mss-nm-7057-aol.nam.nsroot.net,2431
;QuotedId=No
;TrustServerCertificate=Yes
;Encrypt=Yes
;Trusted_Connection=Yes
;Port=2431
;DBParm=CharSet='iso_1',PWEncrypt = 'Yes'
DBParm="ConnectString='Driver={ODBC Driver 17 for SQL Server};QuotedId=No;TrustServerCertificate=Yes;Encrypt=Yes;UID=*******;PWD=*******;SERVER=mss-nm-7057-aol.nam.nsroot.net,2431;'"
;Lock="RR"

Hi Prasad;

  It will be nearly impossible to help you unless you always post the following information with these type of posts...

• O/S version & build
• DBMS Server version & build
• DBMS Client version & build
• SQLCA settings
• PB version & build
• PFC version & build
• When did this issue start?
• Is it always reproducible?
• Does it happen on other PB developers IDE?
• Does this happen when running from the IDE or an EXE?
• If an EXE, is it an M-Code or P-Code compile - 32 or 64 bit?

Regards ... Chris