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

Nick Gorham nick at lurcher.org
Tue Apr 7 00:55:36 BST 2009

Jason Maitlen wrote:
> I’ve been successfully using PHP to run queries with the odbc 
> functions against a datasource configured in /etc/odbc.ini. I copied 
> this DSN over to a new one and redirected to a different host and DB, 
> but it won’t connect. Because of this problem I started messing around 
> with isql and found that neither one of these DSNs worked from isql. 
> Shouldn’t any connection that works from PHP using the odbc functions 
> also work with isql since they use the same DSNs and drivers?
> *Jason Maitlen*
If everything else is the same between PHP and isql, then if one works 
the other will too, if something is different, then maybe not. I guess 
the thing to find is what is different.

You haven't said how isql fails, run with -v to how errors

isql -v dsn user password


More information about the unixODBC-support mailing list