[unixODBC-support] SQLPrepare error

Georges Racinet gracinet at nuxeo.com
Thu Dec 7 13:29:14 GMT 2006

On Dec 7, 2006, at 2:25 PM, Nick Gorham wrote:

> 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

Thanks for the quick reply.

I don't have the box on hand, but I think the above message is  
precisely what -v got me.
I might remember badly, I'll check on that.

> -- 
> Nick Gorham
> Easysoft Limited
> http://www.easysoft.com, http://www.unixODBC.org
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support

Georges Racinet,   Nuxeo SAS
Open Source Enterprise Content Management (ECM)
Web: http://www.nuxeo.com/ and http://www.nuxeo.org/ - Tel: +33 1 40  
33 79 87

More information about the unixODBC-support mailing list