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"
| Product: | PowerBuilder | Category: | Database |
| Version: | 2019 R3 | Build: | 2082 |
OS:
Windows 10
Platform:
All
Database Type:
Microsoft SQL Server
Code:
long lDate
SetPointer(HourGlass!)
If cbx_toolbox.CHECKED THEN
//This is the default date. All records will be retrieved.
lDate = 99999999
ELSE
lDate = is_filters_toolbox.l_date
END IF
return retrieve(is_cusip, lDate)
I am trying to run the menus in the application it gives the mentioned error during runtime in PowerBuilder
