Savita, Log in to the server using the user name, you are using in your ODBC connection. Make sure you can change directory to /datatel/development/coldev if it is not already the home directory. Define unidata environment variable it is already not in the login script. Use udt command to go into unidata if the login script does not do it. Use command like "SQL SELECT * FROM filename" to make sure you have privilege etc. on the file.
Then try ODBC from Access. Regards Kafsat -----Original Message----- From: Louis Guillaume [mailto:[EMAIL PROTECTED] Sent: Friday, 10 September 2004 4:19 PM To: [EMAIL PROTECTED] Subject: Re: [U2][UD] ODBC to UniData 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/ This email and any attachments are confidential and intended solely for the use of the person or entity to whom they are addressed. If you are not the intended recipient, please do not disclose, store, copy or take any action in reliance on it or them. If you have received this message in error, please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete all copies on your system. Any opinion, advice or information in this email is not necessarily that of the owners or officers of this company. Please advise us immediately if you or your employer do not consent to email for messages of this type. Retail Decisions has taken reasonable precautions to ensure that any attachment to this email has been swept for viruses. However, we cannot accept any liability for any damage sustained as a result of software viruses, and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer system may be viewed by other Retail Decisions employees or officers strictly in accordance with law. ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
