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

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
  1. Monday, 27 May 2019 03:47 AM
  2. PowerBuilder
  3. # 1
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.
  • Page :
  • 1


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