firebird-test — Firebird engine testing, test flight/suite discussion/information

Re: [Firebird-test] Firebird Win32 (any version) slow on some Databases on 1st connection.

[Dmitry Y. <di...@us...>]

"mrqzzz" wrote on Sun, 31 Aug 2003 11:19:59 +0000 (UTC):

> Notes:
> -It happens on a few DBs only, and always on the 1st connection after a
> reboot
> -The freeze happens by simply starting a transaction
> -The Dbs are intact and coerent (backup & restore goes ok)
> -There are 20 or 30 tables, many Fk, some Sp, some Views, no Blobs.
> -The time seems to increase with the DB size
> -I had this problem on some DBs ever since old Interbase 5.x
> -The freeze still happens with ANY Firebird version,
> -The freeze happens on ANY Windows version (95/98/Me/2000/XP) even with
> 1 Mb RAM.

Set the sweep interval to zero and perform it automatically at night. It
should be the best solution. Please, send your support questions to
fb-support.


Dmitry

Re: [Firebird-test] Error 104 from "GROUP BY" clause???

[Dmitry Y. <di...@us...>]

"TerryC" wrote on Sun, 31 Aug 2003 11:20:07 +0000 (UTC):

> I have a query that generates an odd error message:

> select s.description Schedule, s.s_date Beginning,
>   r.days_on DaysOn, r.days_off DaysOff,
>   sh.description Shift, sh.s_time ShiftStart, sh.e_time ShiftEnd
> from schedules s
>    join sched_rots sr on s.id = sr.sched_id
>    join rotations r on r.id = sr.rot_id
>    join shifts sh on sh.id = r.shift_id
> group by s.description

> The "group by" clause generates a "SQL Error 104: user name required"
> message.  If I remove that line, the query executes flawlessly.  Whats
> up?

Your query is invalid and your firebird.msg file isn't up-to-date on the
client side. And please don't ask support question here, use fb-support
newsgroup instead.


Dmitry

[Firebird-test] Firebird Win32 (any version) slow on some Databases on 1st connection.

[mrqzzz <mr...@ya...>]

Hi all.
Has anyone experienced this:
After a reboot is done on the Firebird Server (any version) machine running
Windows (any Windows version), i connect to a database (no particular
structure, size about 20 Mb, no Blobs), and connection is immediate (any
client : IBX, IBO, even Java), then as soon as i start a transaction, the
Firebird server "freezes" for several seconds (even 2 minutes on some
DBs!!), the Hard disk looks very busy,  then everything goes on regularly.
Any other further transaction start happens instantly, as it should.
If the server is rebooted, the same freeze happens when the first
transaction is started!

Notes:
-It happens on a few DBs only, and always on the 1st connection after a
reboot
-The freeze happens by simply starting a transaction
-The Dbs are intact and coerent (backup & restore goes ok)
-There are 20 or 30 tables, many Fk, some Sp, some Views, no Blobs.
-The time seems to increase with the DB size
-I had this problem on some DBs ever since old Interbase 5.x
-The freeze still happens with ANY Firebird version,
-The freeze happens on ANY Windows version (95/98/Me/2000/XP) even with 1 Mb
RAM.

I suppose that during this "freeze", Firebird is inspecting the DB
structure...?
Does anybody experience this ????
If someone is interested in testing this issue, e-mail me directly i can
send a 2Mb ZIP with a "freezing" DB.


Any help is really appreciated.
Thanks,
Marcus.

Ps:
I know it's not a big deal...: first connection is slow, so what? Well: i am
having a hard time with laptops users complaining they must wait 2 mins
every time my app is run :((

Re: [Firebird-test] Problem with non joined queries

[Dmitry Y. <di...@us...>]

"Venelin Dimitrov" wrote on Thu, 28 Aug 2003 09:41:18 +0000 (UTC):

>     I can't fetch any records with this query:

> SELECT
>   M.moduleid, M.name, M.path, M.readonly, M.tstamp, M.userid,
>   R.revisionid, R.version, R.revision, U.login, P.projectid, pjM.hidden
> FROM pjmodule pjM, projects P, modules M, revision R
> LEFT OUTER JOIN users U ON M.userid = U.userid
> WHERE
>   pjM.moduleid = 26
>   AND pjM.projectid = 1
>   AND P.projectid = pjM.projectid
>   AND M.moduleid = pjM.moduleid
>   AND R.moduleid = M.moduleid
> ORDER BY
>   R.version,
>   R.revision,
>   P.projectid

I'd prefer such queries to be rejected by the DSQL layer. Never mix SQL89
and SQL92 syntaxes (implicit and explicit joins) in one statement.

P.S. Please post support questions to fb-support. This forum is for the
engine test-suite engineers.


Dmitry

[Firebird-test] Error 104 from "GROUP BY" clause???

[TerryC <tch...@wy...>]

I have a query that generates an odd error message:

select s.description Schedule, s.s_date Beginning,
  r.days_on DaysOn, r.days_off DaysOff,
  sh.description Shift, sh.s_time ShiftStart, sh.e_time ShiftEnd
from schedules s
   join sched_rots sr on s.id = sr.sched_id
   join rotations r on r.id = sr.rot_id
   join shifts sh on sh.id = r.shift_id
group by s.description

The "group by" clause generates a "SQL Error 104: user name required"
message.  If I remove that line, the query executes flawlessly.  Whats up?

Running FB1.5RC5 on NT 4.0 Server, SP4.  Accessing via TCP/IP from Windows
2000 Pro, SP4.

Thanks much,
-Terry

[Firebird-test] Problem with non joined queries

[Venelin D. <ve...@di...>]

    Hi,
    I can't fetch any records with this query:

SELECT
  M.moduleid, M.name, M.path, M.readonly, M.tstamp, M.userid,
  R.revisionid, R.version, R.revision, U.login, P.projectid, pjM.hidden
FROM pjmodule pjM, projects P, modules M, revision R
LEFT OUTER JOIN users U ON M.userid = U.userid
WHERE
  pjM.moduleid = 26
  AND pjM.projectid = 1
  AND P.projectid = pjM.projectid
  AND M.moduleid = pjM.moduleid
  AND R.moduleid = M.moduleid
ORDER BY
  R.version,
  R.revision,
  P.projectid

when I change previous one with this I have no problems

SELECT
  M.moduleid, M.name, M.path, M.readonly, M.tstamp, M.userid,
  R.revisionid, R.version, R.revision, U.login, P.projectid, pjM.hidden
FROM pjmodule pjM
JOIN projects P ON (P.projectid = pjM.projectid)
JOIN modules M ON (M.moduleid = pjM.moduleid)
JOIN revision R ON (R.moduleid = M.moduleid)
LEFT OUTER JOIN users U ON M.userid = U.userid
WHERE
  pjM.moduleid = 26
  AND pjM.projectid = 1
ORDER BY
  R.version,
  R.revision,
  P.projectid

[Firebird-test] Big DB from IB6 to FB1.5

[Andrew V. <an...@ro...>]

Hi, all!

I want move my DB from IB6 to FB 1.5-RC5 classic on Windows 2000 and 2 
CPUs server. I use default options for FB1.5.
Backup IB6/Restore FB1.5 is OK. But when I run test program I get errors 
as "lock conflict on no wait transaction
violation of PRIMARY or UNIQUE KEY constraint "INTEG_980" on table 
"ENTRYCORR_12000101""
IB6/7 and FB1.5-RC5-superserver have _not_ this problem.
This is bug FB 1.5-RC5-classic?

Thanx!

[Firebird-test] running Firebird with boundschecker

[Klement G. - Munich-M. <gkl...@mu...>]

Did somebody test Firebird with a bounds checker tool like Purify?

These tools not only find memory leeks.

I think it's worth an attempt.


Regards
Guenther Klement

RE: [Firebird-test] How to set IB users for FireBird ???

[Leyne, S. <Se...@Br...>]

Darius,

> Please help me, how to set IB users ant grants for FireBird ?

User/developer support questions should be posted to the
Firebird-support list @ YahooGroups.


Sean

[Firebird-test] How to set IB users for FireBird ???

[Darius E. <da...@pr...>]

Please help me, how to set IB users ant grants for FireBird ?

-- 
Pagarbiai
Darius Evseicikas
==================
"PROGMERA"
Maironio g. 3, 4400 Raseiniai
tel./faks. +370 428 70329
mob. +370 699 97390
ICQ 297832308

[Firebird-test] beginner

[Alessandro G. <gr...@gr...>]

hi to all 

i'm a new Firebird user 
i'm using Firebird 1.0 (FirebirdSS-1.0.3.972-0.i386.rpm) 
on Linux and i'm writing some simple test programs in C but with some
problems ... 

i'm using the isc_dsql_execute_immediate to execute a SQL statment
but it fail all time, i use 

the statment i'm testing is :
INSERT INTO "parametro" ("tipo") VALUES ('v');
if i execute this via isql all work fine ... but in C 

strcpy(sqlbuff,"INSERT INTO \"parametro\" (\"tipo\") VALUES ('v')");

all tima fail with 
'Token unknown "parametro"' ... 

without quoting (") 
strcpy(sqlbuff,"INSERT INTO parametro (tipo) VALUES ('v')");

the erros became 
Table unknown PARAMETRO 
yes table name in uppercase ... 

both client and server run on Linux ... 

obviously the attach and start_stansaction are executed correclty
(according to status_vector) ... 


please help !!! 


						<gremlin>
-- 
 /-------------------------------------------------------------\
|           Alessandro Gardich : gr...@gr...             |
 >-------------------------------------------------------------<
|  I never saw a wild thing sorry for itself.                   |
|  A small bird will drop frozen dead from a bough              | 
|  without ever having felt sorry for itself.                   |
 \-------------------------------------------------------------/

[Firebird-test] beginner

[Alessandro G. <gr...@gr...>]

Hi to all ...

I'm new to Firebird and I'm tring to write some simple testing programs.
I have problems with quoting (I suppose).
The problem is : the execution of a statment with
isc_dsql_execute_immediate fail, the same statment in isql work perfectly.

I suppose is quoting cause the statment is 
INSERT INTO "parametro" ("tipo") VALUES ('v');

without quoting (") nothing work ... 
into the C program i use 
strcpy(sqlbuff,"INSERT INTO \"parametro\" (\"tipo\") VALUES ('v');");

the error i obtain is :
---begin---
SQLCODE: -104
SQL ERROR:
Invalid token
 
ISC STATUS:
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 13
-"parametro"
---end---

if i change and delte quoing in C ... 
strcpy(sqlbuff,"INSERT INTO parametro (tipo) VALUES ('v');");
the error become 
---begin---
SQLCODE: -204
SQL ERROR:
Undefined name
 
ISC STATUS:
Dynamic SQL Error
-SQL error code = -204
-Table unknown
-PARAMETRO
-At line 1, column 13.
---end---

obviously the table exist :) 
in fact via isql all work. 

Both my program and isql run on the same computer, on the same server. 
Both client and server run on Linux. 
Firebird 1.0 (FirebirdSS-1.0.3.972-0.i386.rpm)

please help 

thanks in advance

Re: [Firebird-test] firebird 1.5rc3 poor insert performance

[Dunarel B. <du...@gm...>]

Apparently I was mistaken. The poor insert performance was due to the
complexity of the calculations and not to the row insert operation.

Sorry about the stupid remark.

[Firebird-test] Stored Procedure Insert not Calling Trigger?

[Niamh W. <su...@st...>]

Hi All,

Is it true that when a Stored Procedure is used to insert a new record or
update an existing record in a table, that the table's triggers do not get
executed?  I have not read this anywhere but after days of debugging my
trigger and SP code I have come to this conclusion.  Is this True? Known? Is
it just a feature of my lack of experience?

I have sample scripts etc if anyone is interested.

(By the way I'm using Firebird-1.0.0.796-Win32.exe)

Please help!
--
Niamh Walsh
Software Developer
Data Connections Ltd.
sm...@ei...

[Firebird-test] firebird 1.5rc3 poor insert performance

[Dunarel B. <du...@gm...>]

I have written a SP which inserts 2000 rows into one table.

It takes about 1 minute on an p3 500.

When it comens to inserting 3000 rows it seems to never end.

Relative to update operations it seems fine.

Is there any known bug or remedy(configuration)  to this ?

On Oracle it takes about 3 secs on the same machine.

Re: [Firebird-test] downloaded qmdb

[Mark O'D. <mar...@fi...>]

Pavel Cisar wrote:

> 
>>Also i'am on a linux box (rh90) does it work on linux right ?
> 
> 
> You'll see, but I have Python/Linux related trouble with running external 
> apps with stdin/stdout redirection that may be solved with newer versions 
> of QMtest/Python/Linux. It definitely works on Windows.
>

It works on linux, I've run it a few times on mandrake 9.0, so rh 
shouldn't be so different.


Cheers

Mark

[Firebird-test] Error of "Invalid PInvoke metadata format" with Firebird.Net Data Provider

[Glenn S. <gm...@ro...>]

Hi
I just installed the Firebird.Net Data Provider and using their=20
ASP.Net example with the security.fdb database and then a IB6=20
database and get the same error.

Error of Invalid PInvoke metadata format.=20

It bombs on the=20
myConnection.Open();

SDK Framework 1.1
Firebird 1.5
Firebird.Net data provider 1.1

Any suggestions?
Thanks
Glenn

Re: [Firebird-Test] Firebird 1.5 RC2 PROBLEM

[Dmitry Y. <di...@us...>]

"Graham Hardwicck" wrote:
> Not only ISQL causes this crash, but all of the following also cause
> Firebird 1.5 to crash....
> IB_SQL  4.21
> IBVIEW  1.02h
> IBQuery   3.1
> XTG's ODBC driver 16 and 17
> Easysoft's ODBC

Please:

1) Download and try RC3
2) Provide additional information about the mentioned crashes, if still
exist
3) Post your issues to firebird-devel, this forum is related to the server
testing suites


Dmitry

Re: [Firebird-Test] Firebird 1.5 RC2 PROBLEM

[Artur A. <ar...@ar...>]

Hi Graham,

This is not a support list. Use the support list at yahoo groups -
ibs...@ya... - or, for Firebird 1.5 questions use the developers list
at sourceforge.

Please tell us about your problem. "Crash" is not enough.

For now: Firebird Manager is for version 1.0. It does not work with version
1.5 (new version is coming up).

Artur

----- Original Message ----- 
From: "Graham Hardwicck" <gha...@oz...>
Newsgroups: sourceforge.firebird-test
To: <fir...@li...>
Sent: Wednesday, May 28, 2003 12:39 PM
Subject: Re: [Firebird-Test] Firebird 1.5 RC2 PROBLEM


> Not only ISQL causes this crash, but all of the following also cause
> Firebird 1.5 to crash....
> IB_SQL  4.21
> IBVIEW  1.02h
> IBQuery   3.1
> XTG's ODBC driver 16 and 17
> Easysoft's ODBC
>
> Also Firebird Manager 1.0 says that "The Firebird Server is not installed
on
> your computer!".
>
> They all worked fine with Firebird 1.02 !
>
> Graham Hardwick
> ""Sergio B."" <sb_...@ti...> wrote in message
> news:b9l1ad$grj$1...@ne......
> > Hello everyone,
> >
> > I just downloaded the new Firebird 1.5 RC2 version and installed it on
> WinXP
> > after removed the 1.5 RC1 version; now, when I try to start ISQL the
> > firebird server crashes.
> > Why?
> > Is this an unknown bug?
> > Thank you,
> >
> > Sergio B.
> >
> >
> >
> >
> > -------------------------------------------------------
> > Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
> > The only event dedicated to issues related to Linux enterprise solutions
> > www.enterpriselinuxforum.com
> >
> > _______________________________________________
> > Firebird-test mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-test
> >
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: eBay
> Get office equipment for less on eBay!
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>

Re: [Firebird-Test] Firebird 1.5 RC2 PROBLEM

[Graham H. <gha...@oz...>]

Not only ISQL causes this crash, but all of the following also cause
Firebird 1.5 to crash....
IB_SQL  4.21
IBVIEW  1.02h
IBQuery   3.1
XTG's ODBC driver 16 and 17
Easysoft's ODBC

Also Firebird Manager 1.0 says that "The Firebird Server is not installed on
your computer!".

They all worked fine with Firebird 1.02 !

Graham Hardwick
""Sergio B."" <sb_...@ti...> wrote in message
news:b9l1ad$grj$1...@ne......
> Hello everyone,
>
> I just downloaded the new Firebird 1.5 RC2 version and installed it on
WinXP
> after removed the 1.5 RC1 version; now, when I try to start ISQL the
> firebird server crashes.
> Why?
> Is this an unknown bug?
> Thank you,
>
> Sergio B.
>
>
>
>
> -------------------------------------------------------
> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
> The only event dedicated to issues related to Linux enterprise solutions
> www.enterpriselinuxforum.com
>
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>

[Firebird-Test] Firebird 1.5 RC2 PROBLEM

[Sergio B. <sb_...@ti...>]

Hello everyone,

I just downloaded the new Firebird 1.5 RC2 version and installed it on WinXP
after removed the 1.5 RC1 version; now, when I try to start ISQL the
firebird server crashes.
Why?
Is this an unknown bug?
Thank you,

Sergio B.

Re: [Firebird-test] downloaded qmdb

[Pavel C. <pc...@us...>]

Hi,

On 9 May 2003 at 0:07, Marius Popa Adrian wrote:

> and installed all the packages for the python and the last 
> qmtest version from cvs 
> Now how do i start the testing process ? Pavel ?

Did you read the readme and doc for QMtest ? You can use CLI or web GUI 
interface to run it. You have to adjust paths in context file. To run 
tests, just CD to qmdb directory and run qmtest script from there (it 
reside in qmtest /bin directory). Use -gui to start the web gui or -run 
to run it from CLI. Use -C to use specific context file. Tests reside in 
isql subdir/test suite.

> Also i'am on a linux box (rh90) does it work on linux right ?

You'll see, but I have Python/Linux related trouble with running external 
apps with stdin/stdout redirection that may be solved with newer versions 
of QMtest/Python/Linux. It definitely works on Windows.

Best regards
Pavel Cisar

See you at the First European Firebird Conference in May in Fulda,
Germany
http://www.firebird-conference.com

http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information

[Firebird-test] downloaded qmdb

[Marius P. A. <ma...@re...>]

and installed all the packages for the python and the last 
qmtest version from cvs 
Now how do i start the testing process ? Pavel ?
Also i'am on a linux box (rh90) does it work on linux right ?

Re: [Firebird-test] Firebird 1.5 Beta on Windows - How to install?

[Mihai N. T. <mih...@vi...>]

Hi Martin!

Here's a problem I got (tech support lousy).

The problem is that if I run Firebird 1.5 as service under Windows2000
Server and try to
open/create a database, I get the error "database unavailable" and "acces
denied".. When I run
Firebird on the same machine under the same account (administrator, for
example), not as service but as application, it works fine.

Thanks for your help.

Mihai
""Martin Schmid"" <m.s...@eq...> ha scritto nel messaggio
news:006f01c2d393$c540d990$9b0a0a0a@LaptopP4...
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0070_01C2D39C.27054190
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi,
>
> =20
>
> I want to test the lastet beta of Firebird 1.5 on Windows, but I =
> couldn=92t
> find any information how to do this?
>
> Also there is no description about the new files?
>
> =20
>
> Where can I found something abou this?
>
> =20
>
> Mit freundlichen Gr=FCssen - best regards
>
> =20
>
> Martin Schmid
>
> Gesch=E4ftsf=FChrer
>
> EQUITANIA GmbH
>
> Das Programmierteam
>
> Hohenzollernstr. 24
>
> 75177 Pforzheim
>
> Deutschland - Germany
>
> fon +49 7231 13810
>
> fon +49 7231 138199
>
> www.equitania.de
>
> mailto:in...@eq...
>
> =20
>
>
> ------=_NextPart_000_0070_01C2D39C.27054190
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <html>
>
> <head>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
> charset=3Diso-8859-1">
>
>
> <meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
>
> <style>
> <!--
>  /* Font Definitions */
>  @font-face
> {font-family:Verdana;
> panose-1:2 11 6 4 3 5 4 4 2 4;}
>  /* Style Definitions */
>  p.MsoNormal, li.MsoNormal, div.MsoNormal
> {margin:0cm;
> margin-bottom:.0001pt;
> font-size:12.0pt;
> font-family:"Times New Roman";}
> a:link, span.MsoHyperlink
> {color:blue;
> text-decoration:underline;}
> a:visited, span.MsoHyperlinkFollowed
> {color:purple;
> text-decoration:underline;}
> p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
> {margin:0cm;
> margin-bottom:.0001pt;
> font-size:12.0pt;
> font-family:"Times New Roman";}
> span.EmailFormatvorlage17
> {font-family:Arial;
> color:windowtext;}
> @page Section1
> {size:595.3pt 841.9pt;
> margin:70.85pt 70.85pt 2.0cm 70.85pt;}
> div.Section1
> {page:Section1;}
> -->
> </style>
>
> </head>
>
> <body lang=3DDE link=3Dblue vlink=3Dpurple>
>
> <div class=3DSection1>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial'>Hi,</span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span =
> style=3D'font-size:10.0pt;
> font-family:Arial'>&nbsp;</span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>I want to test the lastet beta of Firebird 1.5 =
> on
> Windows, but I couldn&#8217;t find any information how to do =
> this?</span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>Also there is no description about the new =
> files?</span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>&nbsp;</span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>Where can I found something abou =
> this?</span></font></p>
>
> <p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
> style=3D'font-size:
> 10.0pt;font-family:Arial'>&nbsp;</span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'>Mit freundlichen Gr=FCssen - best =
> regards</span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'>&nbsp;</span></font></p>
>
> <p class=3DMsoAutoSig><b><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:11.0pt;
> font-family:Verdana;font-weight:bold'>Martin =
> Schmid</span></font></b></p>
>
> <p class=3DMsoAutoSig><font size=3D1 face=3DVerdana><span =
> style=3D'font-size:8.0pt;
> font-family:Verdana'>Gesch=E4ftsf=FChrer</span></font></p>
>
> <p class=3DMsoAutoSig><b><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana;font-weight:bold'>EQUITANIA </span></font></b><font =
> size=3D2
> face=3DVerdana><span =
> style=3D'font-size:10.0pt;font-family:Verdana'>GmbH</span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'>Das Programmierteam</span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'>Hohenzollernstr. 24</span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'>75177 Pforzheim</span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'>Deutschland - Germany</span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'>fon +49 7231 13810</span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'>fon +49 7231 138199</span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'><a =
> href=3D"www.equitania.de">www.equitania.de</a></span></font></p>
>
> <p class=3DMsoAutoSig><font size=3D2 face=3DVerdana><span =
> style=3D'font-size:10.0pt;
> font-family:Verdana'><a =
> href=3D"mailto:in...@eq...">mailto:in...@eq...</a></span></fo=
> nt></p>
>
> <p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
> style=3D'font-size:
> 12.0pt'>&nbsp;</span></font></p>
>
> </div>
>
> </body>
>
> </html>
>
> ------=_NextPart_000_0070_01C2D39C.27054190--
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: FREE  SSL Guide from Thawte
> are you planning your Web Server Security? Click here to get a FREE
> Thawte SSL guide and find the answers to all your  SSL security issues.
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>

[Firebird-test] Firebird as service

[Mihai N. T. <mih...@vi...>]

Thank you, Craig and Bill, for answering.

The problem is that if I run Firebird 1.5 as service under Windows2000
Server and try to open/create a database, I get the error "database
unavailable" and "acces denied". When I run Interbase on the same machine
under the same account (administrator, for example), not as service but as
application, it works fine.

Thanks for your help.

Mihai