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, I have a .NET web service built with PB 2017 R3 that fails to connect to an ASE 16 database. Web server: Windows Server 2019 / IIS 10 / ASE 15.7 DB client DB server: ASE 16 Webserver is set up with:- PB 2017 R3 runtime files (32 and 64 bit) a...

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

I apologize if this is a basic question, or if I leave out significant details, but this is my first time creating a PowerApp.  I did search the forums and the web, but did not find a good answer.  I am creating a new PowerApp using Powerserver 2022...

Does anyone use Microsoft Always Encrypted for SQL databases and have a successful integration with a Powerbuilder 2021 or 2022 application?We've been requested to encrypt some data and we're trying to figure out possible solutions for a mixed Powerb...

Hi Everyone,   I have an existing PB 2019 project that needs an encryption and decryption of INI file. (the INI file contains database credentials). I don't have any idea how will I'm going to do that, so any help or suggestions would be very much ...

Hi my fellow PowerBuilder enthusiast :-) Can you advise me if PostgreSQL is a good and fast and stable database. Currently using Firebird 2.5 (2.5 is an old version that is really hard to upgrade) and it is unstable sometimes and not fast when datab...

So due to the use of a multitude of cursors and temporary tables that are part of the Oracle database environment that we are working into the PowerServer environment, we stumbled across the ability to use the long_connection option as part of the db...

Ported my app from PB2019 to PB2022R2. German Umlaute like öüäß are no longer working. Database is MySQL8.0. If i write Umlaue in a datawindow column and call dw.update() => next retrieve brings back some weird characters like 'ü' App connects ...

Our software has been developed to support both MS SQL Server & ORACLE depending on the client using the software. With PowerServer 2020 we had both SQL Server and ORACLE set up in our configuration (Database Type section) so the output would sup...

(edit Use Extended Attributes OFF, see print screen) Hello, Our DBA doesn't want those tables in the databases and my applications don't use them. So I have the option Use Extended Attributes OFF, Read Only ON pb.ini in AppData\Local\Appeon\Pow...

Hello, in my application I am connecting to the database using the connection string that is defined in a Registry key, this is my code and as I show you in the attached images, you can see that when I debug my code I am receiving my transaction all...

Like the title says, I'm having a problem with the tutorial where I started with all the demo files except for the database file as far as I could see. Either that, or when trying to connect to the ODB ODBC Database Profile PB SQLServer V2022 it just...

Hi   We are looking for ways to connect PowerBuilder 2021.1506 application to an Azure database. We can connect to the database using: SQLCA.DBMS = "MSOLEDBSQL SQL Server" SQLCA.ServerName = "tcp:<our server>.database.windows.net,<por...