[unixODBC-support] Can't Get isql to Work
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