Re: tsql works, unixODBC's isql doesn't

"Dan Wierenga" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <24CF2B9B9D2BCC4B8F6EA9528B63C8360AE3301D@LA-EXCLUST01.corp.valueclick.com>
Hi Joel,

> -----Original Message-----
> From: [email protected] [mailto:freetds-
> [email protected]] On Behalf Of Joel Fouse
 
> Any help?  Pointers, logging tips, 2x4 upside the head?  I'll take
> anything.
> 
> - joel

I've no idea if this is your problem, but something that tripped me up
was that unixODBC seemed to want my local odbc*.ini files to be writable
at all times.  Since I don't leave files writable by default (an
artifact of using Perforce as my source control) it couldn't/wouldn't
read my local files.  I set my ODBCSYSINI environment variable to point
at my local configuration files i.e. /home/dwierenga/conf/odbc instead
of the system ones in /etc/.  It seemed to be happy with the "system"
ini files to be readonly and thereafter I could connect via isql.

HTH,
Dan
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.