Subject | Cannot open dataset. Dynamic SQL Error SQL error code = -204 |
---|---|
Author | Mike |
Post date | 2010-02-11T12:07:46Z |
Can anyone help with this problem?
I cannot open client dataset. When I set the dataset.active = 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 2.1.3.18185). With IBExpert I can see all the tables and data correctly.
In a Delphi form I am using a TADOConnection and a TADOTable component. The connection component is 'connected' and in the table component I choose the MYTABLE table fronm the drop-down list. When I try to set the TADOTable.Active property to true I receive the error.
Details:
operating system : Windows 7 x64 build 7600
Connection string:
Provider=LCPI.IBProvider.3;Password=masterkey;Persist Security Info=True;User ID=SYSDBA;Location=c:\_work\gaa\firebird\gaa.fdb;
ctype=ASCII;garbage_collect=True;
auto_commit=True;auto_commit_level=65536;bicursor=False;free_threading=True;array_vt_type=True;inner_trans=True;
truncate_char=True;schema_cache=1;support_odbc_query=False;force_prepare_stmt=False;
unicode_mode=False;unicode_stmt=False;clear_param_info=True;auto_param_describe=True;force_param_describe=True;
named_param_prefix=:;ignore_unprepare=True;exec_sp_named_param=False;odbc_call_sp=2;auto_commit_ddl=0;
auto_commit_ddl_level=4096;rowset_vm_using=512;nested_trans=False;ado_exec_sp=2;schema_sp_params=2;
ignore_err_param=0;dbclient_type=ib;support_square_delim_name=0;keywords_list=0;tr_abort_flags=0;
array_type=1;reset_ds_tr_rule=1;numeric_i2_rules=0;numeric_i4_rules=0;numeric_i8_rules=0;
dbclient_lock_rules=1;stmt_cache__time=60;stmt_cache__size=1024;stmt_cache__req_life_time=30;
rowset_file__sys_flags=0;rowset__memory_usage
clUseClient
ilUnspecified
cmShareDenyNone
Regards,
Mike Watson
I cannot open client dataset. When I set the dataset.active = 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 2.1.3.18185). With IBExpert I can see all the tables and data correctly.
In a Delphi form I am using a TADOConnection and a TADOTable component. The connection component is 'connected' and in the table component I choose the MYTABLE table fronm the drop-down list. When I try to set the TADOTable.Active property to true I receive the error.
Details:
operating system : Windows 7 x64 build 7600
Connection string:
Provider=LCPI.IBProvider.3;Password=masterkey;Persist Security Info=True;User ID=SYSDBA;Location=c:\_work\gaa\firebird\gaa.fdb;
ctype=ASCII;garbage_collect=True;
auto_commit=True;auto_commit_level=65536;bicursor=False;free_threading=True;array_vt_type=True;inner_trans=True;
truncate_char=True;schema_cache=1;support_odbc_query=False;force_prepare_stmt=False;
unicode_mode=False;unicode_stmt=False;clear_param_info=True;auto_param_describe=True;force_param_describe=True;
named_param_prefix=:;ignore_unprepare=True;exec_sp_named_param=False;odbc_call_sp=2;auto_commit_ddl=0;
auto_commit_ddl_level=4096;rowset_vm_using=512;nested_trans=False;ado_exec_sp=2;schema_sp_params=2;
ignore_err_param=0;dbclient_type=ib;support_square_delim_name=0;keywords_list=0;tr_abort_flags=0;
array_type=1;reset_ds_tr_rule=1;numeric_i2_rules=0;numeric_i4_rules=0;numeric_i8_rules=0;
dbclient_lock_rules=1;stmt_cache__time=60;stmt_cache__size=1024;stmt_cache__req_life_time=30;
rowset_file__sys_flags=0;rowset__memory_usage
clUseClient
ilUnspecified
cmShareDenyNone
Regards,
Mike Watson