Article View: borland.public.delphi.database.dotnet
Article #70IBScrip and Firebird - Problem
From: Hanno Blackert
Date: Wed, 21 Dec 2005 14:50
Date: Wed, 21 Dec 2005 14:50
43 lines
2098 bytes
2098 bytes
I have just stated to switch an application from Delphi 5 to a Winform
application with Delphi 2006. My first experience to create a Firebird
(V1.5) database by executing an IBScript, as worked fine with Delphi 5, was
disappointing.
I did succeed in creating a database using the params:
Database.Params.Add ('USER ''SYSDBA''');
Database.Params.Add ('PASSWORD ''masterkey''');
Database.Params.Add ('PAGE_SIZE 4096');
Then I connect to that database and I execute a script that I have reduced
to a single instruction:
(Line 1) CREATE DOMAIN BLATTNUMMER AS
(Line 2) VARCHAR(10);
When I issue IBSCRIPT.ExecutreScript, the program hangs.
When I combine the two lines into one line
CREATE DOMAIN BLATTNUMMER AS VARCHAR(10);
I get an exception:
STORE RDB$FIELDS failed. Atempt to store duplicate value (visible to active
transactions) in unique index "RDB$INDEX_2".
which does not make sense to me with a new created database.
Do I have to specifiy "Firebird" somewhere? The Firebird server is running.
Does Delphi2006 eventually try to attach another server that cannot cope
with the script?
I'd appreciate somebody's help.
Hanno
Technical Details
Message-ID:
<43a96b69$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.hal-mli.net!feeder1.hal-mli.net!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 1effe6,8586ae4e481d8be6,start X-Google-Attributes: gid1effe6,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Hanno Blackert" <Hanno.Blackert@aucos.de> Newsgroups: borland.public.delphi.database.dotnet Subject: IBScrip and Firebird - Problem Date: Wed, 21 Dec 2005 15:50:44 +0100 Lines: 45 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 62.225.64.2 Message-ID: <43a96b69$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1135176553 62.225.64.2 (21 Dec 2005 06:49:13 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.hal-mli.net!feeder1.hal-mli.net!news-out.newsfeeds.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail