Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error when running query against Interbase

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

0 Replies