Hello.
I'm trying to connect to fb2.03 database (embedded) wia ver 2.10.0.10.
But I get an error:
"CHARACTER SET WIN1251 is not installed"
PS with TADOConnection everything is Ok (the same database, the same client library, etc...)
PPS I tried to clear parameter "CharSet" at TIBCConnection's options page, but an error does not dissapear.
PPPS And even set to "NONE" value - the same error
can you help me?
error with charset in embedded mode
this is my small sample:
procedure TForm1.Button1Click(Sender: TObject);
begin
IBCScript1.ExecuteFile('inserts.sql');
end;
Used scripts:
ddl script executed in IBExpert on FireBird 2.03 (exact my own script):
SET SQL DIALECT 3;
SET NAMES win1251;
create table testtable(
f1 varchar(10) not null primary key,
f2 varchar(10),
f3 varchar(10)
);
dml script "inserts.sql" executed via TIBCScript (exact my own script):
insert into testtable values('one','two','three');
insert into testtable values('two','three','four');
commit;
These are links to screenshots of my TIBCConnection's properties pages:
http://img371.imageshack.us/img371/5923/1pageaa4.jpg
http://img371.imageshack.us/img371/4278/2pagebx7.jpg
http://img242.imageshack.us/img242/4045/3pagejs3.jpg
http://img371.imageshack.us/img371/3711/4pagezk2.jpg
I'm not trying to insert data in national charset now, but still have an error
procedure TForm1.Button1Click(Sender: TObject);
begin
IBCScript1.ExecuteFile('inserts.sql');
end;
Used scripts:
ddl script executed in IBExpert on FireBird 2.03 (exact my own script):
SET SQL DIALECT 3;
SET NAMES win1251;
create table testtable(
f1 varchar(10) not null primary key,
f2 varchar(10),
f3 varchar(10)
);
dml script "inserts.sql" executed via TIBCScript (exact my own script):
insert into testtable values('one','two','three');
insert into testtable values('two','three','four');
commit;
These are links to screenshots of my TIBCConnection's properties pages:
http://img371.imageshack.us/img371/5923/1pageaa4.jpg
http://img371.imageshack.us/img371/4278/2pagebx7.jpg
http://img242.imageshack.us/img242/4045/3pagejs3.jpg
http://img371.imageshack.us/img371/3711/4pagezk2.jpg
I'm not trying to insert data in national charset now, but still have an error
You should copy firebird.conf file to the directory with your application. In this file you should uncomment and set a value to the RootDirectory parameter. This is the directory where you have placed Firebird embedded server files.
Make sure that the directory with embedded server files has 'intl' subdirectory with the files required for character set support.
See also \doc\README_embedded.txt file in the directory with embedded server files for details.
Make sure that the directory with embedded server files has 'intl' subdirectory with the files required for character set support.
See also \doc\README_embedded.txt file in the directory with embedded server files for details.