Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DB2 & VB6 using MSRDC

83 views
Skip to first unread message

Ali Asghar

unread,
Mar 25, 1999, 3:00:00 AM3/25/99
to
Hello everyone

I was wondering if u could help me out a bit.

i installed db2 V5.2 on a client server enviorment (Win NT), & connected

remote stations via TCP/IP (using DB2 Client App Enabler). now, thru the

db/2 command prompt all is ok, even on the remote wrkstns all test users

and the the 'adminst' (Nt server and DB/2 administrator) can access the
database and write to it with their specific rights.

I't my VB 6 GUI that has problems !!! .. if to my VB form i give the
'adminst' LoginID & Password it can connect and adds to the the DB. But
any other db2 user can only connect and cannot perform any function (i.e

add) on the database.

on my VB form form iv used a component 'MSRDC' (and its object name is
'dtaData' and that handles everything for me; and for adding i use:

dtaData.Updaterow
dtaData.Recordset.Addnew

and the 'Addnew' thing doesn't execute .. it gives an error with any
user
other than 'adminst'.

can u please help me .. im counting on u all !!!

Thank u very much !!!

Regards

p.s. u can email me at: asg...@tdbank.ca

vcard.vcf

Preble

unread,
Mar 25, 1999, 3:00:00 AM3/25/99
to
What is the error ? Maybe you haven't granted to any other ids. Grant
insert,update,delete,select on creator.tablename to authid;

Ali Asghar

unread,
Mar 26, 1999, 3:00:00 AM3/26/99
to
hi
well all the rights work perfectly using the DB/2 command line processor ...
even from remote locations !!!!! ... it's somewhere at the VB (RDO) level that
rights are being restrained ... that's all i could think of !!!!!

... im still in a fix !!!!!

...and thanx for ur concern preb !!!!!

regards

Ali

vcard.vcf

Juan Lanus

unread,
Mar 27, 1999, 3:00:00 AM3/27/99
to
Ali:

May be you are having trouble with the schema name. You must keep in mind that
table names are made of two parts: schema.name, so your table foobar is actually
adminst.foobar ('cause you created it connected as administ).
In my programs I use a "SET SCHEMA" SQL sentence after connection, so that any
user name can access the general schema

HTH

Juan Lanus

kurt wood

unread,
Apr 8, 1999, 3:00:00 AM4/8/99
to Ali Asghar
On your RDO control, make sure the cursor type in set to RdUseODBC. If not,
there may be problems.


Adina Adler

unread,
Apr 8, 1999, 3:00:00 AM4/8/99
to
kurt wood <kurt...@state.mn.us> writes:

> On your RDO control, make sure the cursor type in set to RdUseODBC. If not,
> there may be problems.

I think you mean cursor driver.

--
Adina Adler
Visit the Readercon web page at http://www.mit.edu/~zeno/readercon.html

kurt wood

unread,
Apr 8, 1999, 3:00:00 AM4/8/99
to
You're probably right, I just remember it was a tough problem to figure out....
0 new messages