Chauhan, Savita wrote:
Hi,
I have been trying to connect to our UniData server via ODBC. It connects fine to the demo database. But when I try to connect to my own test database from MS-Access or VSG,
it gives an error message "You don't have permissions to chdir to
/datatel/development/coldev" !!
I create files using Envision API from Datatel in the DEVelopment account/database (/datatel/development/coldev).
The entry in my ud_database file looks like this:
DATABASE=demo UDTHOME=/usr/ud52 UDTACCT=/usr/ud52/demo TRACE_LEVEL=0
DATABASE=test_db UDTHOME=/usr/ud52 UDTACCT=/datatel/development/coldev TRACE_LEVEL=0
I have been fiddling around with so many things, changing permissions on files, changing the ownership, etc, as suggested by a few people; but nothing seems to work!!!
Do I have to make some change/entry in some other file too for me to be able to access the DEV account/database via ODBC?
Can someone tell me what am I doing wrong?
Thanks.
This should be in an FAQ somewhere...
The user who runs unirpcd must be a member of the group that owns the database. I believe user permissions are ignored.
For example...
unirpcd is running as root. the database you're trying to access is /datatel/development/coldev the permissions on coldev are Owner:datatel Group:cdev Perms:770
root MUST be a member of the "cdev" group.
Note the lack of access control unless you set up good views and privileges!
Hope that helps,
Louis
-- Louis Guillaume Berklee College of Music ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
