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: 17.2.0.1880, time stamp: 0x5c4c4727
Faulting module name: PBVM170.dll, version: 17.2.0.1880, 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: