1. Chris Low
  2. PowerBuilder
  3. Monday, 27 May 2019 02:52 AM UTC

because of the need to disable TLS 1.0, i'm moving to the latest sql driver that supports tls 1.2 (unless anyone has better suggestions)

SQLCA.DBParm = "ConnectString='DSN=" + ls_dsn + ";UID=" + sle_userid.text + ";PWD=" + ls_password +"',DelimitIdentifier='No',Date=' \''dd-mm-yyyy\'' ',DateTime=' \''dd-mm-yyyy hh:mm.sss\'' ',Time=' \''hh:mm.sss\'' ',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'"

the following selectblob statement will crash the whole app and debugger

selectblob tblCaseReportTrans.UserReportImage
into :lb_doc
from tblCaseReportTrans
where tblCaseReportTrans.JobReferenceNo = :ls_refno and
tblCaseReportTrans.Reportid = :ls_reportid and
tblCaseReportTrans.create_date = :ldt_create;
if SQLCA.SQLCode < 0 then
f_display_msg("E", 5000, SQLCA.SQLErrText)
end if

Faulting application name: PB170.EXE, version:, time stamp: 0x5c4c4727
Faulting module name: PBVM170.dll, version:, time stamp: 0x5c4c47ff
Exception code: 0xc0000005
Fault offset: 0x001d8efa
Faulting process id: 0x2150
Faulting application start time: 0x01d5143607d15ad0
Faulting application path: C:\Program Files (x86)\Appeon\PowerBuilder 17.0\PB170.EXE
Faulting module path: C:\Program Files (x86)\Appeon\Shared\PowerBuilder\PBVM170.dll
Report Id: ecab7a27-355c-41c8-a2f3-b67d6d70a40d
Faulting package full name:
Faulting package-relative application ID:

Chris Low Accepted Answer Pending Moderation
  1. Monday, 27 May 2019 03:47 AM UTC
  2. PowerBuilder
  3. # 1

ok issue seems to be dbparm related. I'm testing again.

SQLCA.DBParm = "ConnectString='DSN=" + ls_dsn + ";UID=" + sle_userid.text + ";PWD=" + ls_password +"',CursorScroll='Dynamic',DisableBind=1,StaticBind=0,TrimSpaces='Yes',SQLCache=4,ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'"

There are no comments made yet.
  • Page :
  • 1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.