VB 6.0 and IDS 7.31 Connectivity

i2c · #1 (**permalink**) 10-31-03, 05:00

Hi All

I'm using VB 6.0 and want to comunicate with IDS 7.31. I've created form using Data Form wizard, I can only view the data while update/delete is not allow to me.

How can i update/delete teh data using ADO/ODBC?

wicky

gurey · #2 (**permalink**) 10-31-03, 07:31

Quote:

Originally posted by i2c
Hi All

I'm using VB 6.0 and want to comunicate with IDS 7.31. I've created form using Data Form wizard, I can only view the data while update/delete is not allow to me.

How can i update/delete teh data using ADO/ODBC?

wicky

Hi,

Test for permission of user.

Gustavo.

i2c · #3 (**permalink**) 11-01-03, 01:24

There user have all the rights

I'm not sure but I read in one artical that to enable ADO we configure either in SDK or database

wicky

gurey · #4 (**permalink**) 11-04-03, 07:21

Quote:

Originally posted by i2c
There user have all the rights

I'm not sure but I read in one artical that to enable ADO we configure either in SDK or database

wicky

Hi Whicky,

Run "DBACCESS", then "select * from sysusers" and test the user permission: CONNECT, RESOURCE or DBA.
And run "SELECT * from systabauth where grantee = 'the user' ".

Gustavo.

Internet Services

Web Development

Digital Marketing

Consumer Tech