Re: [Firebird-odbc-devel] Driver issues

[Martijn T. <m.t...@up...>]

Hello Alexander,

>>>> I've been experimenting with the Firebird ODBC driver in
>>>> Database Workbench and try to use it, however, I get these
>>>> error messages:
>>>>
>>>> Do a "select * from table order by pk_columns":
>>>>
>>>> [Microsoft][ODBC Driver Manager] Invalid argument value
>>>>
>>>> When using a different cursor type (code modified), I get:
>>>> [Microsoft][ODBC Driver Manager] Fetch type out of range
>>>>
>>>>
>>>> What is the cause for this?
>>>>
>>> What driver do you use? ODBC driver RC1 2.0.0.148? If it is reproduced
>>> on this driver I will look at what is the problem.
>>>
>> Next, use the ADO/ODBC Explorer from the Tools menu.
>>
>>
>>
> I have found a very interesting thing, this program can not get data
> from different sources (I tried Oracle, MySQL, Firebird ODBC drivers)
> but for different reasons.

Hmm, I tried several others MS SQL, MS Access, Oracle (via MS driver)
and they worked fine. Care to let me know the reasons? :-)

> Probably this ODBC tool is enough crude.
> I have looked at Firebird ODBC under debug but I have not seen any
> problems in the driver by operating through this program. The error
> "Fetch type out of range" is more interesting but I did not understand
> how I can modify cursor type. Please help me in this.

You cannot from the program itself, I modified the code for that.

Didn't you get a " [Microsoft][ODBC Driver Manager] Invalid argument value "
when trying? That's what I got at first before I modified the cursor type.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com