Discussions tagged Database
Unable to get ADO connection working using Access Token, please help.
- New
- How-to
- Last updated 22 hours ago
- Jostein Ullestad replied 18 hours 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 ...
.NET web service fails to connect to database
- Advice
- Last updated 1 month ago
- Arnd Schmidt replied 1 month ago
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...
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...
SQL Server login issue with PowerServer Web App
- Issue
- Last updated 3 months ago
- Guillermo Tamburo replied 1 month ago
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...
Powerserver client accessing local database
- Resolved
- How-to
- Last updated 3 months ago
- mike S replied 3 months ago
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...
Powerbuilder 2022 & Microsoft Always Encrypted
- How-to
- Last updated 5 months ago
- Daryl Foster replied 5 months ago
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...
Select Error: ERROR [07006] [Sybase][ODBC Driver][SQL Anywhere]Cannot convert string to a integer
- Resolved
- Issue
- Last updated 5 months ago
- David Xiong @Appeon replied 5 months ago
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...
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...
Encryption/Decryption of INI file in PowerBuilder
- How-to
- Last updated 6 months ago
- Miguel Leeuwe replied 6 months ago
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...
Any gotchas when using the Long_connection dbparm option?
- Advice
- Last updated 11 months ago
- mike S replied 11 months ago
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...
German Umlaute not working
- Issue
- Last updated 11 months ago
- Benjamin Gaesslein replied 11 months ago
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 ...
PowerServer 2022 Support for multiple DBMS
- How-to
- Last updated 1 year ago
- Logan Liu @Appeon replied 1 year ago
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...
PBCATxxx tables creation and errors when disabled
- Issue
- Last updated 1 year ago
- Hugo Moors replied 1 year ago
(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...
reading from the registry to connect to the db
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 9 months ago
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...
Can't connect local SQL server 2019 Express
- Resolved
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
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...
Demo database ODBC not showing in connections list
- Issue
- Last updated 1 year ago
- Miguel Leeuwe replied 1 year ago
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...
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.
...
How I do connect PB 2022 with oracle 12
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
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