Discussions tagged Database

Hi Folks, My application is on PB 2017 R2 and its running on windows server 2012 R2 OS. Application is connecting with local DB which is in SQL anywhere and remote database which is in SQL server. This application is basically fetching the files fr...
Bonjour, J'ai installé hier PowerBuilder 2019 R3 pour mettre à niveau une application développée avec une version précédente et qui utilise une base SQL Anywhere v11. Si l'appli fonctionne très bien sous PowerBuilder 2019 R3, par contre le build de...
Hi all, I am trying to amend the database connection-cache: command timeout - where to do the setting? Thank you. JX ...
Hello, friends. We are testing PB 2019 R3, and we are very excited about the powerclient functionality. At the moment it works fine. But we wonder if there will be any possibility  of connecting  in the same way as web. I mean, work from home. I th...
Hi all. A customer of mine, yesterday, performed a bad processing with our PB application on a Sybase SQL Anywhere 10 database and unintentionally deleted a lot of data in various tables. He has no backup of the db (not to mention) but the 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 ...
  • Page :
  • 1