I've inherited a global network of Interbase 5.1 based databases. I'm writing an application in .Net (don't worry, this isn't a cross post ;-) ) and amongst other things I'd like to incorporate a SQL string parse function that operates in a similar way to that of MS Query Analyser. I've used the SQL Server functions SET PARSEONLY and SET NOEXEC before with no problems, but I don't seem to be able to find an equivalent in Interbase. I've looked at the documentation for IB 5.5 and there is mention of a PREPARE statement that may be useful. I'm connecting to each database via ODBC using the Interbase Intersolv driver v 3.10.00.00. When I try a prepare statement, I get the following error:
This is the same error (more or less) reported when I try running the same sql through the (awful) WISQL tool that comes with Interbase.
I'd appreciate any help received. I should say that any 'upgrade or replace' Interbase solutions are no-go as the current setup will 'have-to-do' until I can replace it with a better solution (like anything!!! ;-) can you tell I've developed a dislike for Interbase??! )
Thanks
Simon
Code:
Microsoft.Data.Odbc.OdbcException: ERROR [37000] [INTERSOLV][ODBC InterBase driver][InterBase]Dynamic SQL Error, SQL error code = -104, Token unknown - line 1, char 0, PREPARE
--- error message truncated
This is the same error (more or less) reported when I try running the same sql through the (awful) WISQL tool that comes with Interbase.
I'd appreciate any help received. I should say that any 'upgrade or replace' Interbase solutions are no-go as the current setup will 'have-to-do' until I can replace it with a better solution (like anything!!! ;-) can you tell I've developed a dislike for Interbase??! )
Thanks
Simon