Subject Re: [firebird-support] Cannot open dataset. Dynamic SQL Error SQL error code = -204
Author Helen Borrie
At 11:07 PM 11/02/2010, Mike wrote:
>Can anyone help with this problem?
>I cannot open client dataset. When I set the = True I receive the following error message:
>"Prepare SQL statement failed. Dynamic SQL Error SQL error code = -204 Table unknown MYTABLE At line 1, column 15."
>I have converted an Access mdb to Firebird (ver With IBExpert I can see all the tables and data correctly.

The only thing here that might be relevant in this list is the way you may have named your converted tables. The name MYTABLE is not the same as "MYTABLE" and neither is the same as "MyTable", "mytable" or any other quoted mixed case name. In standard SQL, defining objects with double-quoted names is significant and some db tools actually do this by default, especially when converting from non-standards-compliant database systems that potentially have undesirable characters in object names.

The rest is off-topic. Please take the question to the IBProvider forum, which is here: