Discussions tagged MSOLEDBSQL

Hi We face an issue related to ADO database connection and are seeking help resolving it. PowerBuilder: 2022 R3 Build 3391 Visual Studio: 2022 DBMS: Microsoft Azure   In short, the issue is that any SQL command fails with SQLCode -1 and no SQL ...
Hi   We are attempting to connect to MSOLEDBSQL using an Access Token, but it is failing. We need some advice on this issue. We have tried the following setups: PowerBuilder 2022 R3 Build 3356 PowerBuilder 2025 Build 3398   We successfully...
Platforms: SQL Server 2022/PB 2022 32bit apps We are considering a new attempt to upgrade from PB 2022 to R3, having abandoned the previous attempt to upgrade to R2, due to the hassle with .NET Desktop Runtime 6.0 on  the client side. There are hund...
  **EDITED TO CLARIFY PREVIOUS SUPPORT, NOT FUTURE SUPPORT** Is Powerbuilder 2021 supported for the new MSOLEDBSQL 18.7.2 drivers released on April 9th this year? Has anyone updated to the newest 18.* driver and had success with existing applicati...
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