Error when running query against Interbase

Thu, 06 Aug 2009 15:01:47 GMT

Hi,

I'm trying to run a query against a Interbase 2007 database.

It's like this:
SELECT * FROM PROCEDURE_POS('01-SEP-2005');

The query is tested from excel and from the "query analyser" for Interbase and works great!

But qlikview gives me the the following error:
SQL Error:[INTERSOLV][ODBC InterBase driver][InterBase]Dynamic SQL Error, SQL error code = -804, Data type unknown, unknown ISC error 335544796

SQL Scriptline:
SQL State:21S01
SQL SELECT * FROM PROCEDURE_POS('01-SEP-2005');

Do anyone have a clue how to fix this?

Thanks,
Kjetil

topic Error when running query against Interbase in QlikView

Error when running query against Interbase