Discussions tagged Database

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...
I have code that i need to use dynamic cursors for to scan for key values in referential testing. database is postgres. the first query must be in sql as the compiler does not recognize the @ character as SQL. it works fine. the second query canno...
Our Powerbuilder application executes a stored procedure in Sybase and has been running without problems for a few years.  About a month ago the stored procedure began stopping without finishing and did not report any error to the calling application...
Hi, My desktop application (built in PB 2017 R3) is connecting to Sybase ASE 15.7 database thru OpenSSL with below configuration: SQLCA.database = ls_ApplDataBaseNameSQLCA.servername = "MyServerName"SQLCA.logid = ls_ApplLoginIDSQLCA.logpass = ls_Ap...
Hi all my fellow PB entusiasts  :-)   What PowerBuilder database interface (oledb,odbc, etc..) do you recommend to use to connect realiably to SQL Server  from a classic windows PowerBuilder application. I'm running up to 50 instances of the same ...
Hello, i have create an appeon app.Wehn i launch it in Powerbuilder it will launch normally. When I deply it and run it via Run, I Become the Error: Connection-Error: Invalid argument I Use a 64 bit Worksation with the Powerbuilder Version: 2019 R2...
Hello all - I tried to search for similar postings on this issue - could not find exact match.  Our Network group is trying to upgrade to Oracle Client 19 and we are currently already migrated to Oracle 19c without any problems, with PB 2017 R2 buil...
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...
Summary: server down, lost files. Details: Trying to recreate production environment for database network server. Have the purchased disc for SQL Anywhere v8.0 and the patch for v8.0.2, but need patch for v8.0.3. Can anyone direct me or provide the ...
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...
  • Page :
  • 1