Solved

Database Transaction information not available

Posted on 2000-03-24
6
5,064 Views
Last Modified: 2008-03-03
Hello,
        I've installed the Complete installation of powerbuilder 5.0 including
the deployment kit and I've made a simple database program using
SQL Anywhere , the program works fine in PowerBuilder environment
but after making an EXE file and launching it
I get a message :

"Database Transaction information not available
Call SetTrans or SetTransObject function
and after pressing OK the Program works
0
Comment
Question by:sameh
6 Comments
 
LVL 9

Expert Comment

by:david_levine
ID: 2656455
Are you getting the error when building or the EXE or running it?

If it's building, make sure you have the write Database profile selected in the Database Profile tool.

If it's when you run it, does the error happen immediately on launching or on the first database access?

David
0
 

Author Comment

by:sameh
ID: 2657189
Edited text of question.
0
 
LVL 9

Expert Comment

by:david_levine
ID: 2658203
Maybe doing the following will help...

Run your program, but specify /pbdebug on the command line. As an example:

your_pb.exe /pbdebug


It will create a log file of everything that happens and it should pinpoint the problem statement. That'll give you(and me) more info on what's causing the error.

David
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Expert Comment

by:Alex_nl
ID: 2660704
This can only mean you forgot to do a SetTransObject() for a datawindow...

Did you change a dataobject dynamically somewhere and did not include the second dataobject in a resource file? After changing the dataobject, you must do a SetTransObject again.

HTH,
Alex
0
 

Accepted Solution

by:
hangtime23 earned 200 total points
ID: 2661675
For each of the datawindows that you have that retrieves data from your database, you need to make the following call :

<datawindow name>.SetTransObject(SQLCA) or you will get that message.
0
 
LVL 1

Expert Comment

by:andres
ID: 2711892
you have to define your sqlca transaction in the aplication script.

sqlca.databasename=....
sqlca.....
....

For each of the datawindows that you have that retrieves data from your database, type:

dw_1.settransobject(sqlca)
dw_1.retrieve()

0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Owning a franchise can be the dream of a lifetime. It provides a chance for economic growth. You can be as successful as you want.  To make your franchise successful, you need to market it successfully. Here are six of the best marketing strategies …
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now