You know...i just thought of something. Login to unix as the same user you're trying to execute the odbc query from. Then cd over to the unidata account (coldev) & drop to TCL. Type LIST VOC = "DV_]"
Choose one of those view names, and then type SQL SELECT * FROM XXX_NF; (Where XXX is one if the views from the list above, i.e DV_XXX_NF) Reason I'm saying to do this, is you're taking the driver out of the picture....plus then you know it's not unix permissions on the schema files, but rather something having to do w/ the driver or uci/rpc connection to this account. -----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" !! 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. ------- 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/
