?
Solved

Database Transaction information not available

Posted on 2000-03-24
6
Medium Priority
?
5,686 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
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

 

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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this modest contribution, I want to share with the IT community (especially system administrators, IT Support Engineers and IT Help Desks) about Windows crashes/hangs and how to deal with these particular problems.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

800 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