I even have the same problem running any parameters. For example:
$ ./odbxtest -b odbc -h WHATEVER_YOU__WANT -p 3004 -d sodbxtest -u crapodino
-w florynano
WHATEVER_YOU__WANT can be a valid DSN or not...it has the same error.
cheers
Mariano
On Tue, Oct 13, 2009 at 1:33 AM, Mariano Martinez Peck <
marianop...@gmail.com> wrote:
>
>
> On Mon, Oct 12, 2009 at 7:36 PM, Norbert Sendetzky <
> norb...@linuxnetworks.de> wrote:
>
>> Hi Mariano
>>
>> > Norbert: I need to make ODBC to work in Windows. I am trying your dlls
>> from
>> > 1.4.4 but i am still having the same problem I had at that time.
>> >
>> > It doesn't matter which ODBC driver I use, I always have the same
>> problem.
>> > It is even before OpenDBX uses the DSN I said in "host" variable.
>>
>> Here's again an excerpt of my mail from last december:
>>
>> 1.) Install the ODBC driver for your database (I used PostgresSQL ODBC)
>> 2.) Control Panel -> Administrative Tools -> Data Sources
>> 3.) As Administrator: System DSN -> Add
>> 4.) Select your driver (I used PostreSQL Unicode)
>> 5.) Enter data source (e.g. pgodbc) host, database, user, password
>> 6.) Press "Test" button (-> should say "Connection successful")
>> 7.) Execute "odbxtest -b odbc -h pgodbc ...
>>
>> Does this work for you?
>>
>>
> 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;
> }
>
>
> when I could put the printf that time, I got this values
>
> SQL_TXN_READ_COMMITTED: 2
> SQL_IS_UINTEGER: -5
>
> I would appreciate you give me some more lines to print everything you
> need.
>
> The thing is that as this line is BEFORE the SQLConnect I ALWAYS have that
> error.
>
> I give you more information: I create a ODBC datasource to an SQL Server
> database and the ODBC test is ok. It uses the driver
> C:\WINDOWS\system32\sqlsrv32.dll and the C:\WINDOWS\system32\odbc32.dll.
> If I remove sqlsrv32.dll and run this test, I have an error. Then I run
> the OpenDBX tests and I got what I told you. Look at the screenshot I
> attach. There you can see the specification of the datasource, the
> successfully result of the test, and the failure of opendbx. The message is
> in spanish.
>
>
> But when I run the OpenDBX tests, the ODBC it is using is
> C:\WINDOWS\system32\odbc.dll (not C:\WINDOWS\system32\odbc32.dll). In
> addition, I can the test even removing sqlsrv32.dll or odbc32.dll and there
> is no dll error. So...those dlls are not being used. Anyway, odbc32.dll and
> odbc.dll are exactly the same.
>
> Even weird...if I remove odbc.dll (whih is needed) I get the famous windows
> popup saying he cant find the dll but after pressing "ok", openDBX continues
> and there is where I get a problem I told you. This is weird, because after
> a problem like that one, it should exit, not continue....
>
> I am completely lost.
>
> I even took a clean PC but I have the same problem.
>
> Any ideas?
>
> Thanks
>
> Mariano
>
>
>>
>> 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
>>
>>
>
------------------------------------------------------------------------------
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
