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

Nick Gorham nick at lurcher.org
Tue Apr 7 17:03:13 BST 2009


Jason Maitlen wrote:

>Nick wrote:
>  
>
>>Is the host of 0.0.0.0 intentional ?
>>
>>If it is, also check if you are reading the same odbc,ini that PHP was.
>>    
>>
>
>It was set like that by my predecessor and I've left it alone since it seems to be working.
> 
>I'm not sure how to check that it's using the same odbc.ini file, but I believe it is because when I change the name of the DSN it:
>  * breaks the PHP script
>  * from isql I get "[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified" instead of "[S1000][unixODBC][Caché ODBC][State : S1000][Native Code 11001] [CacheODBC.so]" which implies to me the Caché driver is being called.
>
>
>If this helps you understand how PHP is configured, here's the odbc info from my phpinfo():
>  
>
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.

-- 
Nick


More information about the unixODBC-support mailing list