Discussions tagged Database

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...
Hi Guys We have an application that we want to deploy using PowerServer. The core database will be cloud hosted that all works fine. However, the app needs to connect to a 3rd party database that will be on the Clients local network. How do I config...
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 Team,   We just used PB2022 R3 to deploy one of our products on PowerServer. We are seeing odd problems with datatype conversion on one of the application's screens. I am only receiving the error in the Powerserver deployed app, even though it d...
  **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 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...
Hi, I have installed PB 2022 R2 and MS SQL Server 2019 to a Windows 2019 server on Azure. While installing PB I could not connect to SQL server to install demo database. Now same problem when I try to create Power Server Project. From PB IDE I ca...
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...
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. ...
Good afternon. Please, how do I add an new option ORACLE 12 in my list "INSTALLED DATABASE INTERFACES"? My powerbuilder is 2022 and I have oracle cliente 12.1. Today I use connected with option "O10 Oracle 10g", but we are going to migrate for orac...
  • Page :
  • 1