[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Database Transaction information not available

Posted on 2000-03-24
6
Medium Priority
?
5,853 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 

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 400 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With the evolution of technology, we have finally reached a point where it is possible to have home automation features like having your thermostat turn up and door lock itself when you leave, as well as a complete home security system. This is a st…
An overview of cyber security, cyber crime, and personal protection against hackers. Includes a brief summary of the Equifax breach and why everyone should be aware of it. Other subjects include: how cyber security has failed to advance with technol…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

650 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