1. Chris Low
  2. PowerBuilder
  3. Monday, 27 May 2019

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:

Chris Low Accepted Answer Pending Moderation
0
Votes
Undo

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'"

Comment
There are no comments made yet.
  1. Monday, 27 May 2019
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.