[freetds] unixODBC/FreeTDS Questions

Rob Garcia rgarcia at tiagris.net
Thu Apr 1 22:16:42 EST 2004



James K. Lowden wrote:

> On Wed, 31 Mar 2004, Rob Garcia <rgarcia at tiagris.net> wrote:
> 
>># isql ebill_auth sa pass -v
>>[IM002][unixODBC][Driver Manager]Data source name not found, and no 
>>default driver specified
>>[ISQL]ERROR: Could not SQLConnect
> 
> ...
> 
>><<<odbc.ini>>>
>>[ODBC Data Sources]
>>
>>[ebill_auth]
>>         Driver          = TDS
>>         Description     = radius auth server
>>         Trace           = No
>>         Servername      = ebill_auth
>>         Database        = ebill_main
>>         UID             = sa 
> 
> ...
> 
>>Results of 'odbcinst -j':
>>
>># odbcinst -j
>>unixODBC 2.2.8
>>DRIVERS............: /usr/local/etc/odbcinst.ini
>>SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
>>USER DATA SOURCES..: //.odbc.ini
> 
>                        ^^^^^^^^^^^
> 
> Is that expected?  A '.odbc.ini' file in the root?  Above, you show the
> contents of a file named 'odbc.ini' (no leading dot).  Is it possible the
> DM is not reading that file?  
> 
> --jkl

Good point!

I copied the '*.ini' files from the '/usr/local/etc' directory to the 
'/' and '/export/home/rgarcia' directories, renamed them adding the 
leading dot, changed file ownership, and got the same results.


Rob





More information about the FreeTDS mailing list