Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Urgent: plz help
4 views
Skip to first unread message
wafa khan
Jul 1, 2010, 7:06:34 AM7/1/10
to
Hi, i am using powerbuilder 10.0. and at backend, using sql server
2005. please help me to connect to the database and also the code of
connectivity. what is the code of making transactions between
powerbuilder and sql server 2005 database.
thanks alot.
2005. please help me to connect to the database and also the code of
connectivity. what is the code of making transactions between
powerbuilder and sql server 2005 database.
thanks alot.
Jeremy Lakeman
Jul 1, 2010, 7:52:38 AM7/1/10
to
1. I'd probably create an ODBC connection, get it working in the IDE
and copy the correct syntax from the dialog. I should be able to find
and post an example tomorrow from work.
2. I'd suggest encapsulating the following in a set of functions on
your own transaction object (eg create a new class inherited from
transaction)
// begin transaction
sqlca.autocommit=false
// commit
commit using sqlca;
sqlca.autocommit=true
// rollback
rollback using sqlca;
sqlca.autocommit=true
0 new messages