Hi

I have a problem when using ODBC driver.
Basicly I dont think its a FB problem, but I want to be sure.

DB: Firebird 1.5.4 running on a Windows 2003

ODBC: Version 1.x Beta, Most Recent
6 Jun 2006 (Beta V1.03.00.0096)

In the ODBC windows in the administrative tools I have set up a Systen
DSN.
Its connecting through the internet.
When "TEST CONENCTION" is done its connection fine.

But the program that uses the connection gives me this error in the
LOG file:

Error in GetLanguages: System.Runtime.InteropServices.COMException
(0x80004005): Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 13
[
at ADODB.RecordsetClass.Open(Object Source, Object
ActiveConnection, CursorTypeEnum CursorType, LockTypeEnum LockType,
Int32 Options)
at DWIWindowsService.DwiWindowsService.GetLanguage()


Among others.

As I read this, and as I have seen with i.e. MS SQL it looks like the
SQL is:

Select xx from [TABLE] ....

And that the [ is not reconised by FB.

Is this correct ?


Michael