Discussions tagged Database

We are trying to program the offline part of the mobile and we have some doubts (we are using a SQLite database):   Can we know every moment if the terminal is in online or offline mode? How   If we run first connect online, how can we then...
I have approached this issue in the past without success. I am hoping that I can provide A LOT more information and someone can point me in the right direction. I have a client/server application that has been upgraded to PowerBuilder 2017. I am wan...
Hello! guys, i hope that you can to help me. i have a PowerBuilder 2019 application and i'm trying use the SqlCa transaction object outside of the thread principal of the app, these cause inside of the shared object i need to retrieve some data but ...
Can someone please provide guidance on how to configure a database connection to use SSL to a Sybase ASE database?  I need to know how to connect from both the Powerbuilder IDE and, separately, from a client/server application. We are currently usin...
Hello, I am new to PB community and recently our company purchased and installed 2019 standard license to migrate PB9.0 application we had, which was last  updated in 2010.  Created a  DB profile , giving connection Error " Please connect as PB cata...
This may be more of a question I can post on the dotnet forums but I wanted to asked for the expert opinion from the Appeon community first. Lets say I create a web api from my data windows using the C# generator. I want to have a database for each ...
What is our need: When a user logs into the app all data written to and retrieved from the database needs to be unique to their tenant. Where we are now: Our app is going from the desktop client/server to the web. Data was physically separated by ...
I'm trying to generate C# web service for a progress database and keep getting the error.... [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about ") = 'autoincrement' then 1 else 0 end AS" (107...
Hello all, I am trying to build a report through composite data window and my child data windows have different retrieval arguments (one is bounded by date whereas the other one is a list of all items). What I need to do is display the pieces of the...
This is the server we are using The application loads. After the password is entered these are the messages that appear and I believe in this order.   This is AEM data source. There is only 4 items that appear in the ODBC Data Source dropd...
Hi, we are in the process of building a Web API with SnapObjects. In PowerBuilder, we support either Sql Server or Oracle with the same table structure. For number columns we use "int" in Sql Server and "number(38)" in Oracle. Unfortunately that le...
Hi, Trying to deploy a simple app as a test to PowerServer Web on a remote server via the Toolkit.  The "Database Type Profile Configuration" screen "Test Connection" Fails with the simple message "Failed to connect to the database" using either ODB...
Hi I am trying to insert some data to my database and I am getting a right truncation error - so i turned of the error checking for the erros . The data has many international characters in it. I now get a primary key exists because the data is tru...
Hi.   We have a small application (PB2017 R3) which reads and interprets small text files, adds rows to 3-4 datastores and the commits to 4 tables in the database. Sometimes it can be as much as 1500 rows, but for the most between 700 and 1000. Th...
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 ...
Hi All I am trying to save a pdf file in database and then fetching pdf data from database to create pdf file from it. BUT the created pdf file is not being opened showing message that it damaged or corrupt. Here are the implementation details Powe...
Hi all, I would like to create a Data Access Layer for my PB application; it would need at least 3 (little) objects for each database table. Since my database has about 200 tables, what would you suggest: create a single pbl with 600 objects; cr...
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 ...
Dear Appeon Team and PB Experts, We know there is a workaround for Appeon PB2019 to support Oracle 18c by installing Oracle 12c Client, Thanks to Chris Pollach and Olan Knight for your replies :) Do you know when Appeon Powerbuilder will fully supp...
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