[unixODBC-support] Can't Get isql to Work

[Nick Gorham]

Jason Maitlen wrote:

>Nick wrote:
>  
>
>>Well, the error you are getting makes me think the app is using unixODBC 
>>to find the driver, but then eitehr the driver can't read the ini file, 
>>or it is reading the file and doesnt like what it finds.
>>
>>Try setting ODBCINI
>>
>>export ODBC=/path/to/your/odbc.ini
>>
>>then try isql.
>>    
>>
>
>That's it!
>
>export ODBCINI=/etc/odbc.ini got it working. 
>
>I can now successfully connect to the previously working DSN and am getting the same error that PHP was returning for my new DSN. The error I'm getting with that is:
>
>  [S1000][unixODBC][Caché ODBC][State : S1000][Native Code 499]
>  [CacheODBC.so]
>  UNKNOWN MSG
>  [ISQL]ERROR: Could not SQLConnect
>
>I believe this is a database specific or driver specific error and not an issue with isql since I get it in both PHP and isql. Thanks for getting me going on isql!
>
>-- Jason Maitlen
>  
>
You may find its missing some message catalogs. But thats just a  guess.

-- 
Nick