What I do remember....is logging in as the person that created the schema, let's call that account 'sqlmgr'. Then, I did a whoami (I think from the directory that had the sticky bit set...like in your case, /datatel/development, and it showed me as root. But, since root didn't have privilege (not permission, but SQL privilege), I couldn't access the schema files. But I'm not sure if you actually see your 'effective permission', or if we did some sort of trace that showed me my effective permission when trying to execute?
Tell me...do you have unidata support (or application support that's a reseller for unidata?) I worked with one of the guys at IBM on this problem...i think it was Paul Chang) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Davis, Dawn Sent: Thursday, September 09, 2004 12:47 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData I DID have the same problem, but can't remember how I fixed it :( I know this may not make a whole heck of alota sense...but for some reason I went into the registry on my local pc, found the reg key for the pathname of the datatel db, and typed in manually the rest of the pathname, as editing the uciconfig file thru the uciconfig editor program wouldn't allow the whole pathname. Obiously, opening the file w/ notepad or something would also do the trick, but for some reason the registry key would not be updated. Also, someone somewhere said to have ONLY the required info in the uci.config file. Here are the contents of mine: [ODBC DATA SOURCES] <Datatel> DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = xxx.xxx.xx.xxx Try taking OUT the db pathname from this file. See if it works. Dawn Janel Davis DBA II [EMAIL PROTECTED] (410) 386-8058 Carroll Community College 1601 Washington Road Westminster, MD 21157 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Thursday, September 09, 2004 2:26 PM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] ODBC to UniData 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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/