Discussions tagged Database Driver
Migrating from SAP ASE -> MS SQL, which DB driver to choose from?
- Resolved
- Advice
- Last updated 2 months ago
- Trevor Holyoak replied 3 hours 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 8 months ago
- Roland Smith replied 8 months 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 10 months ago
- Chris Pollach @Appeon replied 10 months 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 1 year ago
- Chris Pollach @Appeon replied 1 year 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 1 year ago
- Chris Pollach @Appeon replied 1 year 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 2 years ago
- Armeen Mazda @Appeon replied 2 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 2 years ago
- Kai Zhao @Appeon replied 2 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 3 years ago
- John Fauss replied 2 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 3 years ago
- mike S replied 3 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 3 years ago
- Antonin Krejci replied 3 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...
SQLOLEDB to MSOLEDBSQL datetime parameter issue
- Issue
- Last updated 3 years ago
- Ken Guo @Appeon replied 3 years ago
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...
Powerbuilder 2019 - MS SQL Server - DB Error - SPs not returning values
- Resolved
- Advice
- Last updated 3 years ago
- John J replied 3 years ago
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...
Using O10 DBMS to connect to oracle 12c database
- How-to
- Last updated 4 years ago
- Olan Knight replied 4 years ago
Hello everyone
The DBMS I'm using now is O10, the oracle client is 11g, and the database server is 12c. Officially, if the client is 11g or 12c, the DBMSs need to use ORA, so I have a few questions.
1. Why did I use O10 to connect to the database w...
Could not connect to sybase db from powerbuilder
- How-to
- Last updated 4 years ago
- sharmistha sinha replied 4 years ago
Hello I am trying to migrate powerbuilder 12.6 to powerbuilder 2017. But I get some problem while connectiong to database. I use SYBASE DB. The error which I get id "Error loading client library DLLs. Unable to connect to server" Can you please help...
"Impersonation" using different Windows AD System account
- How-to
- Last updated 4 years ago
- Kim Berghall replied 4 years ago
Hello all,
I'm a longtime (more than 22+ years) PowerBuilder developer. We have upgraded to PowerBuilder 2017 R2 through Appeon.
I have a question about the support for “Impersonation” using a different Windows AD System account after logging into ...
changing to ODBC for sql server 17. application/debugger crashes on selectblob
- Issue
- Last updated 4 years ago
- Chris Low replied 4 years ago
because of the need to disable TLS 1.0, i'm moving to the latest sql driver that supports tls 1.2 (unless anyone has better suggestions)
SQLCA.DBParm = "ConnectString='DSN=" + ls_dsn + ";UID=" + sle_userid.text + ";PWD=" + ls_password +"',DelimitIde...
Hello Appeon Powerbuilder team,
We have a Power builder application which migrated from power builder 9.0 to power builder 2017R3. The database used was Oracle 11g. the 11G client has no issues connecting with PB2017R3. The problem lies with the ...
SQLCA.Database v/s SQLCA.DBParm Database
- How-to
- Last updated 4 years ago
- Roland Smith replied 4 years ago
Hi,
Is SQLCA.Database = "DatabaseName" not supported by "SNC SQL Native Client(OLE DB)" driver?
The connection object fails to connect to the database unless it's passed as SQLCA.DBParm = "Database='databasename',Provider='SQLNCLI11'"
I ...
- Page :
- 1