Re: - users looking in the wrong place

James Mitchell Ullman wrote:
> Greetings all, I'm a little new to the ODBC scene, so please inform me
> of any missteps I've taken or any assumptions I should avoid making(like
> any).
>
> I've got a problem with unixODBC.  The root user can configure and
> access everything just fine, however regular users cannot.  The
> particular programs in the suite in question are isql and ODBCConfig.  I
> have done an strace of both and have found that while root is looking
> for the configuration files odbc.ini and odbcinst.ini in the correct
> place(/usr/local/etc), regular users are looking for it in
> /usr/etc//odbc.ini and /usr/etc//odbcinst.ini.
>
> I compiled from source in the following manner:
> ./configure --prefix=/usr/local
> make;make install
>
> My system: RedHat Linux 9
>
> My version of unixODBC: 2.2.5
>
> Any help is appreciated.
> Cheers!

I would guess that as you have RH9 the uses are finding the RH version 
of unixODBC and the root one is finding the version you built. Try a

which isql
/* and using the isql path from above */
ldd isql

both as root and a user, see if you get a different result.

--
Nick Gorham

Easysoft Limited
web: www.easysoft.com
tel: +44 (0)1937 860000
fax: +44 (0)1937 860001

This email from Easysoft Limited is intended only for the personal use
of the recipient(s) named above.  The email and any files transmitted
with it are confidential to the intended recipient(s) and may be legally
privileged or contain proprietary and private information.  If you are
not an intended recipient, you may not review, copy or distribute this
message.  If received in error, please notify the sender and delete the
message from your system.

Any views or opinions expressed in this email and any files transmitted
with it are those of the author only and may not necessarily reflect the
views of Easysoft and do not create any legally binding rights or
obligations whatsoever. Unless otherwise pre-agreed by exchange of hard
copy documents signed by duly authorised representatives, contracts may
not be concluded on behalf of Easysoft by email.

Please note that neither Easysoft nor the sender accepts any
responsibility for any viruses and it is your responsibility to scan the
email and the attachments (if any).  All email received and sent by
Easysoft may be monitored to protect the business interests of Easysoft.