Discussions tagged Database Driver
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...
Nexus for DB drivers
- How-to
- Last updated 7 months ago
- Francisco Martinez @Appeon replied 7 months ago
It's possible to use our nexus oss to download informix driver ?!
I try to create db connection and SnapDevelop try to download informix driver from nuget.org.
How to change setting to use our nexus oss to download informix drvier ?!...
Error "DBMS MSOLEDBSQL SQL SERVER is not supported in your current installation"
- How-to
- Last updated 7 months ago
- Chris Pollach @Appeon replied 7 months ago
We are attempting to transition from ODBC to MSOLEDBSQL Version 19.3.3, but when we try to connect our Transaction, we get the error in the title of this post:
"DBMS MSOLEDBSQL SQL SERVER is not supported in your current installation"
This is from ...
Best Driver to connect to SQL Server 2019/2022
- How-to
- Last updated 8 months ago
- Andreas Mykonios replied 8 months ago
Hi there,Currently we use ODBC to connect to SQL Server 2019/2022, but we want the best possible performance and as such we're looking for the best practice in this regard.
We're using Powerbuilder Version 2022, Build 1878.
Thank you in advance for...
SQL Native Client
- Resolved
- How-to
- Last updated 8 months ago
- Chris Pollach @Appeon replied 8 months ago
Hi all
PB 2022 R3 Windows 10 SQL Express 15
I have always used SQL Anywhere for my database however I have a new project that requires me to connect to a SQL server database
Can you confirm what i am getting is normal - i thought you could just co...
SAP IQ Database Connection From PowerBuilder application Error
- Issue
- Last updated 9 months ago
- Miguel Leeuwe replied 9 months ago
Dear everyone,
I am having an issue creating a IQ db connection from our application. I do not wish to use ODBC connection (I tried it's working fine).
On my computer and user computer SAP IQ Client Suite 16.0 sp08 (64-bits) is installed. My P...
CVE-20240--0056 Sql Server Native Client high alert
- Issue
- Last updated 10 months ago
- Julie Jiang @Appeon replied 10 months ago
With CVE-2024-0056 (SQL Server high security alert) what versions of Powerbuilder are affected and what is the Appeon advice on avoidance of this issue.(ref: NVD - CVE-2024-0056 (nist.gov))...
Hello,
I'm trying to generate a Runtime Installer but i don't have the Oracle.ManagedDataAccess installed.
Do you know how can i install this driver?
Greetings,
Edi
...
Migrating from SAP ASE -> MS SQL, which DB driver to choose from?
- Resolved
- Advice
- Last updated 1 year ago
- Trevor Holyoak replied 1 year ago
Hi,
After developing for more than 25 years on a Sybase (SAP ASE) database, we are migrating to MS SQL. We are using the native ASE interface for our database connection. We have some large Powerbuilder applications that rely heavily on this databas...
PB 2022 connectivity error with SQLOLEDB
- Resolved
- How-to
- Last updated 1 year ago
- Roland Smith replied 1 year ago
Hi Experts,
******************************************************************
Database Versions: Microsoft SQL Server 2014/Microsoft SQL Server 2019
******************************************************************
I have upgraded my existing ...
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...
PowerClient - Database driver
- How-to
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
Hi
How do you install database drivers (and other shared resources) through PowerClient?
What's the best practice?
Before Powerclient I had a regular installer ( made with Wix ) which made a separate folder in program files. Therefore applications...
32-bit ODBC for SQL Anywhere
- Resolved
- How-to
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
When choosing a Database Configuration for the PowerServer project, it only lists 64-bit SQL Anywhere 17 odbc's.
Is it not supported with 32-bit ODBC?...
Our ORACLE version is not available (currrent is 11g) ,Is it possible to choose the old appeon version?...
Connect options from PowerServer to databases
- How-to
- Last updated 3 years ago
- Armeen Mazda @Appeon replied 3 years ago
Hi,
The new PowerServer 2021 provides only few possible possibilities for database providers:
Is there more options coming and with what timetable?
Could it be possible to use all ODBC-drivers installed on the server?
Is it possible to use driv...
Power client installation of batch file
- Resolved
- How-to
- Last updated 3 years ago
- Kai Zhao @Appeon replied 3 years ago
Good day,
Need help for the powerclient... I read this article indicating the steps on the deployment.
"
Advanced usage of External Files and Preload Event
The combination of External Files and Preload Event can streamline the process of deployin...
SQL server connection and SQLCA.DBMS / SQLCA.DBParm
- How-to
- Last updated 4 years ago
- John Fauss replied 3 years ago
Hi.
I have struggled with getting the SQLCA properties set up correct to be able to have my users connect to data base with single sign-on/trusted connection. I'm on MS SQL Server.
The problem boiled down to using correct value for SQLCA.DBMS. Than...
PB 2019 and Informix Database Connection
- Resolved
- How-to
- Last updated 4 years ago
- mike S replied 4 years ago
Hello,
Environment info:Powerbuilder 2019 R2 Build 2353Database: Informix 12.10.FC13 running on Linux serverInformix client: 4.10.TC14 (32 bit) and 4.10.FC12W1 (64 bit)PB App and Informix Client running on Windows 2008 Server R2 (Service Pack 1)
ED...
Hi, hopefully someone can help
I am getting an error in my application which is 32 bit pb2019 when i run it on windows 2016 RDS
Error =
datawindow error
Select Error: Decimal conversion error. Powerbuilder supports only 18 digits.
Also on some ...
PB2017 Oracle 19 timestamps handled as date
- Issue
- Last updated 4 years ago
- Antonin Krejci replied 4 years ago
Hello,
I would like to ask about the PB Oracle DB driver
We have PB2017R2 (1756) & Oracle client 11.2 and DB Oracle 11.2
with migration to Oracle DB 19 I face issue where the Timestamps are handled as dates instead of Timestamps and because o...
- Page :
- 1