[unixODBC-support] SQLPrepare error

Nick Gorham nick.gorham at easysoft.com
Thu Dec 7 13:25:38 GMT 2006

Georges Racinet wrote:

>     I'm trying to connect to an iSeries/AS-400 server using unixODBC.
>     I  must admit I'm quite new to the ODBC world.
>     unixODBC will be used from a python library (egenix' mxODBC), but
>     that's another story.
>     The driver is correctly registered in /etc/unixODBC/ odbcinst.ini, 
> and
>     it appears in the ODBCConfig graphical interface.
>     my odbc.ini file is well configured enough that I can browse the
>     tables in DataManager, but
>         - I don't see the frame where I'm supposed to issue SQL 
> statements
>       (compared to the screenshot from the online manual)
>         - Using isql, I get an "SQLPrepare, can't prepare" error.
Add the -v option to show any errors returned by the driver

isql -v dsn user password

Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

More information about the unixODBC-support mailing list