Brio.Report problem 1

[Patten]

Hey,

anybody out there having experience with Brio.Report on Teradata?

I am trying to create a report in Brio.Report. I am able to connect to Teradata but when I want to run my report I get an ODBC error being:

(SQR 5528) ODBC SQL dbftch error 0 in cursor 1:
[Microsoft][ODBC Driver Manager] Driver does not support this function

Error on line 30:
(SQR 3725) Bad return fetching row from database.

SQR: Program Aborting.


Doing the same report while connecting to a SQL Server database everything works fine.
Does Brio.Report not support connectivity to Teradata?
Because in my ODBC Administrator I see different drivers: SQR ODBC Driver for DB2, SQR ODBC Driver for Informix etcetera but not a SQR ODBC Driver for Teradata...

Teradata version: v2r4 on Windows 2000
ODBC Driver: 3.00.01.01
Brio Report Builder 6.0

 

[brioboy]

There is a pre-fetch default of 10 with every begin-select. Teradata does not support this, however if you include the -b1 along with your begin-select it will work.