[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