[unixODBC-support] Can't Get isql to Work
nick at lurcher.org
Tue Apr 7 17:03:13 BST 2009
Jason Maitlen 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
then try isql.
More information about the unixODBC-support