Discussions tagged Database Driver

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 ...
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...
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...
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...
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  ...
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...
Hi Experts, ****************************************************************** Database Versions: Microsoft SQL Server 2014/Microsoft SQL Server 2019  ****************************************************************** I have upgraded my existing ...
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...
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...
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?...
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...
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...
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...
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 ...
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...
PB 19 Build 2082 SQL SERVER 2017   Upgrading our driver from SQLOLEDB to MSOLEDBSQL and now get issues w/ SQL's DBPARAMBINDINFO.     PROBLEM: MSOLEDBSQL conflicts w/ the Now() function in that the driver only wants 3 milliseconds instead of No...
Hi All, I'm trialing PowerBuilder 2019 to upgrade an existing application currently on PB9. Did an auto upgrade using PB2019 and everything compiled well. Modified the code block to connect to MS SQL 2014 DB using OLE DB (I assume thats the best cho...
  • Page :
  • 1