Discussions tagged MSOLEDBSQL

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)...
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. ...
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...
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...
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