Discussions tagged Transaction
We have a PB classic application migrating to PS (latest PB etc.), connecting to Oracle 19 database. When the application runs in PS it is not encapsulating multiple SQL statements in a transaction, almost as though a commit is issued between each s...
Hi Team,
We have met an issue about using the Transaction connecting to Sybase database.
It shows below error when connect failed:
Error Code:-1Error Text:ct_connect(): user api layer: external error: The maximum number of connections have alread...
Hi, I have a desktop application developed in PB 2017 R3. It is connecting to the database (Sybase ASE 12.5) using the global transaction object SQLCA. To connect to the db, we are setting the trans object as:
SQLCA.Database = "MyDB"SQLCA.Servernam...
Hi.
My application has started pop up a message box on some data fetches.
The message is "Select error: SQL State = 22005 ... Invalid character for cast specification"
This may have started when I changed the connection to a newer SQL server. The ...
Hi
Can anyone tell me whether it is possible to have a nested report connected to a different transaction object and if so how to.
So the report might be on SQLCA - sales database and the sub / nested report on the SQLCB - personel database
the m...
Hello,
Trying to check if a transaction object is connected to a database, I'm calling its DBHandle() function. When the objects is not connected, this call yields the transaction object DBError event. How can this be worked around?
PB 12.5.1 b 459...
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."-------------------------...
DB Connection Issues w/ Mobile deploy w/ Native Microsoft SQL Server
Summary
Have not been able to deploy as mobile application and go beyond the database connection. Have tried using native and ODBC and have failed numerous times. PB2017 Help con...
We have multiple users, using same .exe from shared folder (shared folder exist in server), recently i installed the Application first time for one new user but a error is coming
like "Transaction already connected", remaining all users its workin...
- Page :
- 1