Solved

Database Transaction information not available

Posted on 2000-03-24
6
5,169 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Cannot view sybase SCC in browser using Linux 5 1,789
Sybase SQL Anywhere ISQL 8 963
Sybase sample database 13 679
How to get the table names associated with a server 3 56
Note: This is the second blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   Every month t…
An analysis of the phishing scam that has been affecting Google users, along with steps to take for protection, as well as what to do if you receive one of the emails.
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…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 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

12 Experts available now in Live!

Get 1:1 Help Now