Discussions tagged MSOLEDBSQL
Cannot get raiseerror from procedure called using RPC
- Resolved
- How-to
- Last updated 1 month ago
- Aleš Vojáček replied 1 month ago
Hi all,
I'm using RPC to call MSSQL stored procedures.
local externa function on transaction object
function long PORADI_DNE(datetime DATUM,ref int SEKVENCE) RPCFUNC ALIAS FOR "dbo.PORADI_DNE"
If there is
raiserror ('Error from procedure',3,1)...
Support for MS SQL Server 2022 and new MSOLEDBSQL Drivers
- Resolved
- Misc
- Last updated 1 year ago
- Roland Smith replied 1 year ago
Hi,
what are the plans for supporting MS SQL Server 2022 and Versions of the MSOLEDBSQL19 newer 19.0.0?
According to the PB Help only MS SQL Server Versions up to 2019 are supported and only the MSOLEDBSQL19 Driver Version 19.0.0 is supported.
...
Increase column sizes on hundreds of datawindows
- Advice
- Last updated 2 years ago
- mike S replied 2 years ago
Greetings community,
In the past few months, our company migrated multiple applications from Powerbuilder 9 to Powerbuilder 2019.
We did encounter something interesting: for varchar(max) and text column types, on our MSSQL database, all datawind...
MSOLEDBSQL - SqlState 42000 OLE DB Driver for SQLServer Incorrect syntax near X
- Resolved
- Issue
- Last updated 2 years ago
- Kevin Geist replied 5 months ago
When I do CTRL L to verify my event code, I get errors that indicates MSOLEDBSQL throws a SqlState 42000 OLE DB Driver for SQLServer Incorrect syntax near 'xxx'
Yet, when I run this code connecting to this database, the code works, the imbedded sql...
Comparison of methods accessing SQL Server from PowerBuilder
- Advice
- Last updated 3 years ago
- Roland Mühlberger replied 3 years ago
Dear PowerBuider Programmers,
this might emerge as a philosophical question, but I still hope to get some answers:
PowerBuilder allows many different ways to access Microsoft SQL Server databases from classic (client/server) PB windows applications...
Hello Appeon team,
I am evaluating PB 2019R3, since PB 2017R3 is not compatible with the new driver MSOLEDBSQL.
Even if we add “DataTypeCompatibility = 80”, the values of the columns of datetime will be truncated (for example, "2021-02-02 14:50:...
- Page :
- 1