RE: Client - Server

Hi Raul

There's an article in the Pro VIP edition of this month's (June 2007)
"System i News" magazine about connecting VB and RPG applications with data
queues which might suit your purposes better.

Using data queues the processing and database updates would be done at the
server end so you would have full control of your commitment control
processing.

All the best

Jonathan

-----Original Message-----
From: midrange-l-bounces+jonathan.mason=astradyne-uk.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+jonathan.mason=astradyne-uk.com@xxxxxxxxxxxx] On
Behalf Of Wilt, Charles
Sent: 29 June 2007 14:06
To: Midrange Systems Technical Discussion
Subject: RE: Client - Server

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Raul A. Jager W.
Sent: Friday, June 29, 2007 8:47 AM
To: Midrange Systems Technical Discussion
Subject: Client - Server

Recently I got a beatifull (Looking) visual basic program to
enter/maintain purchase orders using ODBC to the iSeries.

For this program to work I had to give the user *CHANGE
access to the "order_header" and "order_detail" tables.

Now I have to questions:

1- How can I keep this user from reading the tables from
other programs like exel?

You can't really. Nor can you keep them from changing the data.

Instead of allowing the user to sign on with there own profile, you could
have the application use its
own specific profile.

Another option, your application could call stored procedures instead of
accessing the data directly.

There are of course other options.

2- How can I define "commitment control" to avoid "half trasactions"
when the program fails?

OBDC driver uses commitment control by default. Unless you've turned it
off, you are using commitment
control. However, it is probably working per automatically "statement"
instead of the per transaction
you want.

While I don't recall the specifics off the top of my head, you need to set a
property on the
connection that turns off auto-commit and allows your application to issue
the commits as appropriate.

HTH,
Charles



This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not a
named addressee you are hereby notified that you are not authorized to read,
print, retain, copy or disseminate this communication without the consent of
the sender and that doing so is prohibited and may be unlawful. Please
reply to the message immediately by informing the sender that the message
was misdirected. After replying, please delete and otherwise erase it and
any attachments from your computer system. Your assistance in correcting
this error is appreciated.