What do you get when you use do the following at the SQL prompt in your coldev account. At the SQL prompt.
sql> SELECT COUNT(*) FROM 'filename'; -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Friday, September 10, 2004 10:29 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Hi All, Our network was down yesterday and couldn't check any mails. I read a lot of mails this morning. Thanks. The problem is that I cannot even 'connect' to my test database (/datatel/development/coldev) via ODBC, whereas I face no problems while connecting to the demo database. This is what my privilege files look like in the coldev account: Privilege access fields grant_op grantor grantee PUBLIC*__V__VIEW SELECT 0 SYSTEM PUBLIC*privilege SELECT 0 SYSTEM 669*XCF_SAVITA_TEST OWNER I had deleted XCF_SAVITA_TEST but the entry still shows in the privilege file!! What other entry do I need to have in this file? If I don't add anything to this file, does it mean I cannot access any of the files? The permission on privilege is -rwxrwx---. On the unix prompt I can change to any directory I want to and on udt I can list / select any file I want to. But while trying to CONNECT to my database, it fails with "You don't have permission to chdir to /datatel/development/coldev". Do I have to set some privileges on the database as a whole to be able to connect via ODBC? If yes, how? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kafsat taiyus Sent: Friday, September 10, 2004 2:25 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2][UD] ODBC to UniData 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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
