From: Alexander P. <ale...@re...> - 2009-01-28 12:26:50
|
Martijn Tonies wrote: > 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. 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. Regards, Alexander |