Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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