We are having problems making VSG and Uniobjects operate in the Datatel environment (ie we can't get multi-values to work right now and our sql server admin switched boxes on us, and the ODBC connection appears to be failing). Here is what I have learned to date.
Datatel has written a VOC entry for ODBCLOGIN. Check it out and see if you need to add anything or remove it. The privilege file is key and it is local to your account. You may need to be superuser and GRANT privileges (I had to). If you had SAFARI installed in your devel account (or live and copied VOC entries over), email me off list for more on this one. We are an AIX site v 5.2, Unidata 6.0.3 and Colleague 17.471. HTH Debra >>> [EMAIL PROTECTED] 9/9/2004 2:26:15 PM >>> I tried logging in as root to connect. That didn't work either !! I guess the permissions don't apply to root or does it?! Isn't there anyone out there, who had the same problem and remembers how to fix? I guess not, otherwise you would have replied by now. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Cook Sent: Thursday, September 09, 2004 12:19 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Hmmm...well I wish I could remember exactly how we fixed it, but I have a feeling it's something to do w/ the effective permissions of the person you're logging in as (who I'm assuming is the owner of the schema files...that is, the person who created the schema?) Since the sticky bit can change the effective user id of the person who's executing a file/cmd, then I think it might be seeing you as someone other than the owner of the schema files, and not allowing you to connect. I'm sure there's someone on the list who's a more experienced unix admin that I....who might be able to help prove out (or disprove) this theory? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 9:53 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData Forgot to add something: The permissions on the demo database (/usr/ud52/demo) are: usr : drwx r-x r-x ud52 : drwx rws --- demo : drwx rws --- The permissions on my test database (/datatel/development/coldev) are: datatel : drwx rwx --- development : drwx rws --- coldev : drwx rwx --- The permissions on demo and my test database are almost the same except for the first directory. Does unix treats a user as 'others' if he/she tries to connect via ODBC, even though I have to enter my user id and password to connect? My earlier reply: All the directories have rwx for 'owner' and 'group'. Do I need to have it for 'others' too? The permissions are like this: drwx rwx --- for datatel and coldev. The sticky bit is set on development though as drwx rws --- . ------------------------------------------------------------------------ --------------------------------------------------------------------- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bullock Sent: Thursday, September 09, 2004 11:34 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData If I remember correctly, you have to have rwx permission on every directory in the path, i.e. rwx permission on /datatel, on datatel/development, and on datatel/development/coldev Jim > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita > Sent: Thursday, September 09, 2004 7:50 AM > To: [EMAIL PROTECTED] > Subject: [U2][UD] ODBC to UniData > > 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" !! > ===== "Never doubt that a small group of thoughtful committed people can change the world: indeed it's the only thing that ever has!" Margaret Meade __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail ------- 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/ ------- 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/