Discussions tagged Database Driver
PowerClient - Database driver
- How-to
- Last updated 2 weeks ago
- Chris Pollach @Appeon replied 2 weeks 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 3 weeks ago
- Chris Pollach @Appeon replied 3 weeks 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 9 months ago
- Armeen Mazda @Appeon replied 9 months 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 1 year ago
- Kai Zhao @Appeon replied 1 year 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 1 year ago
- John Fauss replied 1 year 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 1 year ago
- mike S replied 1 year 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 2 years ago
- Antonin Krejci replied 2 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 2 years ago
- Ken Guo @Appeon replied 2 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 2 years ago
- John J replied 2 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 2 years ago
- Olan Knight replied 2 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 2 years ago
- sharmistha sinha replied 2 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 3 years ago
- Kim Berghall replied 3 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 3 years ago
- Chris Low replied 3 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 3 years ago
- Roland Smith replied 3 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 ...
What if I want to continue using DBMS=MSSQL and not DBMS=SNC
- How-to
- Last updated 3 years ago
- Roland Smith replied 3 years ago
Hi,
Is there a way I can avoid changing database provider/driver from Microsoft SQL Server (MSSQL NTWDBLIB - I now this will not be supported by MS) to MS SQL Native Client (SQLNCLI11) ?
Thanks!
...
ADO.NET - not able to set Application NAme
- Resolved
- How-to
- Last updated 3 years ago
- Georgios Papageorgiou replied 3 years ago
Hi Powersphere
When i connect to SQL Server 2017 i'm not able to set the Application Name.
Currently the "sp_who2" says ".Net SqlClient Data Provider"
I tried to set DBParm to
"Application Name=Client" / "App='Client'" / "ApplicationName...
Host parameter in DbParm doesn't work in Appeon web environment
- Resolved
- How-to
- Last updated 3 years ago
- Oscar Naranjo replied 3 years ago
Hi everyone,
We are migrating a PowerBuilder application to the web with PowerBuilder 2017 universal version, our database connection has always been using a username master so we always put the real user's name as a connection parameter of the data...
- Page :
- 1