ODBC error when using report wizard

[Richard_Ward_(Guest)]

Hi,__we have a customer who is trying to create a report based on a large view. The following error occurs after the view has been selected as the master table in the report wizard:____DB access: (Data Direct)(Oracle Wire Protocol driver) In SQLExtendedFetch, only SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY cursors____The same view can be used OK when creating a blank report, or if a master table is modified on an existing report.____The view also functions OK from within our application using the same datasource.____The drivers in use are Oracle Wire Protocol Drivers 4.2 and connect to an Oracle 8i database.____Any help or ideas on this would be apreciated.____Regards,____Richard Ward__Software Support Engineer__Warwick International Computing Systems

[kfleming]

After the blank report is created, can you add fields to the layout and have them display successfully?______Kathleen__R&R Support

[Richard_Ward_(Guest)]

The blank report works fine, fields can be added and viewed OK, just seems to be in the report wizard at the point of selecting the mater table.____Had quite a few reports of problems selecting views in report wizard now, but not got all the details together as they all seem to be different errors. Will post them here when I have a list.____Richard Ward__Software Support Engineer__Warwick International Computing Systems__

[Taavi_Remmelg_(Guest)]

Hi,__ we have the same problem here with Firebird ODBC, did You find any solution?____Can You create reports without using wizard?____ ____>Hi, __>we have a customer who is trying to create a report based on __>a large view. The following error occurs after the view has __>been selected as the master table in the report wizard: __>__>DB access: (Data Direct)(Oracle Wire Protocol driver) In __>SQLExtendedFetch, only SQL_FETCH_NEXT is supported for __>SQL_SCROLL_FORWARD_ONLY cursors __>__>The same view can be used OK when creating a blank report, __>or if a master table is modified on an existing report. __>__>The view also functions OK from within our application using __>the same datasource. __>__>The drivers in use are Oracle Wire Protocol Drivers 4.2 and __>connect to an Oracle 8i database. __>__>Any help or ideas on this would be apreciated. __>__>Regards, __>__>Richard Ward __>Software Support Engineer __>Warwick International Computing Systems __

[Taavi_Remmelg_(Guest)]

Hi, __ just for people with the same problem:__Firebird ODBC developers fixed this cursor type issue for us and with latest drivers ____OdbcJdbc v1-3-Beta Ver 01.03.00.0077 or __OdbcJdbc v2-0-Beta Ver 02.00.00.0100__from http://www.praktik.km.ua/____our reports worked OK with R&R SQL 10 and Firebird ODBC datasource.________>Hi, __> we have the same problem here with Firebird ODBC, did You __>find any solution? __>>Hi, __>>we have a customer who is trying to create a report based on __>>a large view. The following error occurs after the view has __>>been selected as the master table in the report wizard: __>>__>>DB access: (Data Direct)(Oracle Wire Protocol driver) In __>>SQLExtendedFetch, only SQL_FETCH_NEXT is supported for __>>SQL_SCROLL_FORWARD_ONLY cursors __>>__>>The same view can be used OK when creating a blank report, __>>or if a master table is modified on an existing report. __>>__>>The view also functions OK from within our application using __>>the same datasource. __>>__>>The drivers in use are Oracle Wire Protocol Drivers 4.2 and __>>connect to an Oracle 8i database. __>>__>>Any help or ideas on this would be apreciated. __>>__>>Regards, __>>__>>Richard Ward __>>Software Support Engineer __>>Warwick International Computing Systems __