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