Discussions tagged MSOLEDBSQL
Unable to get ADO connection working using Access Token, please help.
- How-to
- Last updated 6 days ago
- Armeen Mazda @Appeon replied 4 days ago
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 ...
Connecting to MSOLEDBSQL using access token, issue with the DBparm length
- How-to
- Last updated 1 month ago
- Peter Pang @Appeon replied 1 month ago
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...
Support for Powerbuilder 2021 and new MSOLEDBSQL 18.7 Drivers
- Resolved
- How-to
- Last updated 5 months ago
- Andreas Mykonios replied 5 months ago
**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...
Cannot get raiseerror from procedure called using RPC
- Resolved
- How-to
- Last updated 10 months ago
- Aleš Vojáček replied 10 months 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 3 years ago
- Kevin Geist replied 1 year 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