-
Sekhar Chitta
- PowerBuilder
- Friday, 28 March 2025 06:00 PM UTC
We are using Powerbuilder 17 R3 and using the native odbc driver version 10 for sql server.
We are doing migration from Sybase to SQL server.
When the datawindows that are having stored procedures as datasource are retrieved, PB still sends the escape syntax to sql server.
I set the dbparm CallEscape=No as the dbparm property in the application ini file
Below is an example:
EXEC dbo.procedure_name 12345,{ts '2024-01-01 12:50:49.677000'}
I also changed the pbodb170.ini settings for SQL Server
PBDateTime='MSSQLSERVER_DATETIME'
PBFunctions='MSSQL_FUNCTIONS'
PBSyntax='MS_SQLSERVER_SYNTAX'
Complete connect string:
"ConnectString='DRIVER={SQL Server};SERVER=xxxxx;DATABASE=xxxx;PORT=xxx;PROTOCOL=xxx;UID=xxxx;PWD=xxxx',staticbind=0,DisableBind=1,StripParmNames='Yes',CallEscape='No',TrimSpaces=1,TrustServerCertificate='Yes'"
How to make PB send the date/time formats that SQL server can understand?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.