Norbert: Hi! did you see the coments from Stefan Kapusniak ? do youhave
something to say ?
http://bugs.linuxnetworks.de/index.php?do=details&id=24&area=comments#tabs
Cheers
Mariano
On Fri, Oct 16, 2009 at 10:54 AM, Mariano Martinez Peck <
marianop...@gmail.com> wrote:
> The same happens with the ODBC driver for Excel. There is a guy who want to
> use SqueakDBX to do selects from an Excel. If you take a clean pc, you
> create a ODBC datasource for excel, with a certain .xls and then you try
> OpenDBX, you will have the same problem.
>
> Maybe a hack (I don't know if this is a solution) would be to try to set
> those options and if there is an error with a particular option, it is
> ignored hahaha. Moreover, maybe there is a way to as if the particular
> option is supported or not. In that case, we can ask first before trying to
> set a value.
>
> Cheers,
>
> Mariano
>
>
> On Fri, Oct 16, 2009 at 9:57 AM, Mariano Martinez Peck <
> marianop...@gmail.com> wrote:
>
>>
>>
>> On Thu, Oct 15, 2009 at 5:03 PM, Norbert Sendetzky <
>> norb...@linuxnetworks.de> wrote:
>>
>>> Hi Mariano
>>>
>>> > No. I ALWAYS have the error "option type out of range" (translated from
>>> > spanish to english). The problem seems to be:
>>> >
>>> > -2719: Option type out of range
>>> >
>>> > ODBC Error. A function was called with an invalid value for the
>>> argument
>>> > fOption (e.g. the functions SQLSetConnectOption() or SQLTransact()).
>>> >
>>> > The problem is odbc_odbx_bind, where you do:
>>> >
>>> > gen->err = SQLSetConnectAttr( gen->conn, SQL_DEFAULT_TXN_ISOLATION,
>>> > (SQLPOINTER) SQL_TXN_READ_COMMITTED, SQL_IS_UINTEGER );
>>> > if( !SQL_SUCCEEDED( gen->err ) )
>>> > {
>>> > return -ODBX_ERR_BACKEND;
>>> > }
>>>
>>> I've tested myself and got the same error with MinGW odbc.dll.
>>
>>
>> I don't think it is a MinGW odbc.dll problem. I tested in a clean PC
>> without MinGW (just the opendbx dlls) and same results. I just tried to
>> connect to a SQL Server database using the odbc driver that comes with
>> Windows, and I got the same results.
>>
>>
>>> The problem is
>>> that it doesn't seem to support the "read commited" isolation level.
>>> Furthermore, it doesn't seem to support another option as well. I have to
>>> do
>>> some investigations to see how we can work around this.
>>>
>>> Thanks for your excellent debugging :-)
>>>
>>>
>>> Norbert
>>> --
>>> OpenPGP public key
>>> http://www.linuxnetworks.de/norbert.pubkey.asc
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
>>> is the only developer event you need to attend this year. Jumpstart your
>>> developing skills, take BlackBerry mobile applications to market and stay
>>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>>> http://p.sf.net/sfu/devconference
>>> _______________________________________________
>>> libopendbx-devel mailing list
>>> libopendbx-devel@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
>>> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>>>
>>>
>>
>
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
