Connection with a 4D-database

[Greetje Coninckx <greetje.coninckx@VIRCO.BE>]

Hello!

We use two databases: one is Oracle, the other is 4D.
The BrioQuery and BrioReporting (SQR) is working OK with Oracle.
The BrioQuery is working also OK with 4D (we use the ODBC Driver for 4D
Server). But still stays a problem to use BrioReporting with 4D: when we try
to use the same driver, the following message appears when processing the
created report:

(SQR 5528) ODBC SQL dbftch error 0 in cursor 1: [Microsoft][ODBC Driver
Manager] Driver does not support this function.
Error on line 31: (SQR 3725) Bad return fetching row from database.
SQR: Program aborting.

To document our environment:
The Brio.Report Builder says about the SQR version: SQR Server/5.1/PC/
Windows NT 4.0/ODBC Level 2/Aug 19 1999

What is strange, is that the in the Expression Builder that can be called
inside the BrioReportBuilder, the 'Show values' button show us some values
coming from the 4D database.

Can it be that the reason why it will not work is the lack of a SQR ODBC
Driver for 4D (because for Oracle we use the SQR ODBC Driver for Oracle8)?


Greetje Coninckx


__________________________________
Greetje Coninckx
Information Technology Analyst
V 1.33
Virco
Generaal De Wittelaan L11 B4
B-2800  Mechelen
Belgium
Phone:  +32 15 285 613
Fax:    +32 15 286 346
__________________________________