Discussions tagged Database

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 ...
Hello all ,   I have a client / server database application . Sometimes when I am running reports ( dw ) , after about a minute I get an error message says something like:  can not complete operation due the time elapsed ….  and sometimes its wo...
Hi, How are people copying files (images or other files) from Appeon Mobile apps to their server? I am trying trying to use UPDATEBLOB to store the image in the database but the below code is throwing the following error: "Error Code: 10999. Object...
A customer is experiencing an issue in which their PowerBuilder 2017 GA application. Users are losing DB connections and the PowerBuilder application crashes. Sometimes such error coincides with a network “flap”, and several users report it at the s...
I have a problem configuring Appeon enterprise manager(AEM) for converting into web. I was not able to connect to an oracle native driver or an ODBC. Its says "Problem occurred when running in 64 bit mode with the 32 bit oracle component installed". ...
I am using PB 2017 R2 and SQL Server 2017.  The following test code works when running on a desktop.  When running on a mobile device (iPad) I get error "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION."-------------------------...
  • Page :
  • 1