At 02:19 PM 05-12-00 -0500, you wrote:
>Anyone know if there is a Netware version of IB6?  If so, where could
>I get it from.  I have a client that swears by Netware....


No, there isn't such a beast, so far.  There is a Firebird group
considering a port to Netware 5.   A Netware 4 port is unlikely,
considering Novell is discontinuing support for it from next October.

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________

> It's taking IBConsole a LONG time to log in to a remote server.

have you tried connecting to the same server through other means in order to
isolate whether it is an IBConsole issue or perhaps it is a general issue.

Does adding a hosts entry for the server name help? This would remove the
need to do a DNS lookup on the network.

Just a thought,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

Please excuse the rank newbie question, but I'm sure I'm missing
something.

It's taking IBConsole a LONG time to log in to a remote server.

I've installed IB6 on our NT 4 (SP6) Server and configured it to use
TCP/IP.

Ive installed IBClient, Local IB and IBConsole on one of our
workstations.

IBConsole is VERY responsive when logging in to the local server. It
is dog-slow when logging into the remote server. It does eventually
log in.  Connecting to a database on the server takes a similarly
long time but is also, eventually, successful.

I'm pretty sure this can't be normal, but poring over the IB6 docs
hasn't revealed anything helpful.

Suggestions?

Thanks in advance.

At 08:15 PM 12/5/2000 -0300, hpc wrote:

>Exists any problem with Windows Millenuim and IB 5.6 with ODS 9.1?
>In the same PC I have an Database with ODS 9.0 ...no problem
>but other with ODS 9.1 I have serious problems ...both run over IB 5.6
>All this ocuurs with a development in Delphi 4.0 and also with de ISQL

I don't know, but a description of the problems might help.  As
far as I know, no one has done a comprehensive test of V5.x on
Windows ME.


Regards,

Ann
www.ibphoenix.com
We have answers.

Exists any problem with Windows Millenuim and IB 5.6 with ODS 9.1?
In the same PC I have an Database with ODS 9.0 ...no problem
but other with ODS 9.1 I have serious problems ...both run over IB 5.6
All this ocuurs with a development in Delphi 4.0 and also with de ISQL

Thanks in advance

Anyone know if there is a Netware version of IB6?  If so, where could
I get it from.  I have a client that swears by Netware....

Thanks,


Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com

Greetings All,
Is there a way to have a declared string variable in a stored proc and then
perform an insert into a blob field?


TIA,
Kevin

What I want to do:

declare variable STally Varchar(255);


sp main body:
STally = STally || F_FIXEDPOINT(Pcs,0) || '/' || CLU || ' ';

insert into my_table(id, blobfieldname)
values(:id, :STally)

At 10:12 PM 12/5/2000 +1100, Helen Borrie wrote:

>Yes, it should be sub-second.  I think the problem is in the CONTAINING
>clause - I always get confused about this but I *think* containing doesn't
>use the index (or maybe CONTAINING does use it and STARTING WITH
>doesn't).

Helen - the way to remember is that the index can only be used from the
beginning of the key - just as a compound index will be used if you supply
values for the first columns defined, a partial string match will use an
index iff the value is at the beginning of the key.  Containing makes no
such assumption.  Starting with does - that's why it exists.  Like can go
either way.  If the query includes a literal comparison value (Bram%) then
it will use an index.  If the query passes a variable, or if the literal
comparison starts with a wild card, the index can not be used.


Regards,

Ann
www.ibphoenix.com
We have answers.

At 11:46 AM 12/5/2000 +0100, Bram wrote:
>
>SELECT STREET FROM POSTCODE WHERE STREET CONTAINING 'BRAM'
>
>There are actually 130 streets in Holland containing my first name. But it
>takes about 10/15 seconds before its returning the 130 rows with an
>IB_Query set on active. Is there a way to check if the query is 100% optimized.
>
>Could it go faster ?

The containing operator can not use indexes, so it must read
all records.  If you are looking for streets starting with "Bram"
either the starting with operator or like "Bram%" is optimized
with an index.


Regards,

Ann
www.ibphoenix.com
We have answers.

At 01:56 PM 05-12-00 +0200, you wrote:
>Yess! It was about time to fix this

LOL !! 90 million mathematical theorists might or might not agree with you !

For a paper on the issue, see

http://www.math.grin.edu/~stone/courses/fundamentals/IEEE-reals.html

Cheers,
H.

>Riho-Rene Ellermaa
>senior programmer
>Hansabank
>lds
> >
> >
> > Dialect 1 store this field as FLOAT using the IEEE definition
> > and so what
> > you store is not always what you get. Try to create the database in
> > dialect 3. It will store this field internally using an
> > INT64. This should fix
> > the problem.
> >
> > []s
> >
> >  Carlos
> >  WarmBoot Informatica - http://www.warmboot.com.br
> >  Interbase-BR - http://www.interbase-br.com
> >
> >
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________

Yess! It was about time to fix this

Riho-Rene Ellermaa
senior programmer
Hansabank
lds
>
>
> Dialect 1 store this field as FLOAT using the IEEE definition
> and so what
> you store is not always what you get. Try to create the database in
> dialect 3. It will store this field internally using an
> INT64. This should fix
> the problem.
>
> []s
>
>  Carlos
>  WarmBoot Informatica - http://www.warmboot.com.br
>  Interbase-BR - http://www.interbase-br.com
>
>

Dialect 1 store this field as FLOAT using the IEEE definition and so what
you store is not always what you get. Try to create the database in
dialect 3. It will store this field internally using an INT64. This should fix
the problem.

[]s

  Carlos
  WarmBoot Informatica - http://www.warmboot.com.br
  Interbase-BR - http://www.interbase-br.com

RRE> No , 1
RRE> Are there any problems when changing to 3?

RRE> Riho-Rene Ellermaa
RRE> senior programmer
RRE> Hansabank

RRE> s
>>
>>
>> Are you using IB 6.0 with dialect 3 ?
>>


RRE> To unsubscribe from this group, send an email to:
RRE> ib-support-unsubscribe@egroups.com

No , 1
Are there any problems when changing to 3?

Riho-Rene Ellermaa
senior programmer
Hansabank

s
>
>
> Are you using IB 6.0 with dialect 3 ?
>

This query will not be optimized because the containing clause will not use
the index :-( If you want only the strees that begin with BRAM so you can
use STARTING WITH. Starting with will use the index and so will be much
faster.

[]s

  Carlos
  WarmBoot Informatica - http://www.warmboot.com.br
  Interbase-BR - http://www.interbase-br.com

B> With the help from the ibobjects lists I created a database/table with about
B> 450.000 records with all street names in the Netherlands.

B> CREATE TABLE "POSTCODE"
B> (
B>        "ID"      INT64         NOT NULL,
B>    "STREET"       CHAR(    50) CHARACTER SET NONE,
B>      "CITY"       CHAR(    50) CHARACTER SET NONE,
B>  "POSTCODE"       CHAR(     7) CHARACTER SET NONE,
B>  CONSTRAINT "PK_POSTCODE" PRIMARY KEY ("ID")
B> );

B> CREATE ASC INDEX "POSTCODE" ON "POSTCODE" ("POSTCODE");
B> CREATE ASC INDEX "STREET" ON "POSTCODE" ("STREET");

B> I created the following query :

B> SELECT STREET FROM POSTCODE WHERE STREET CONTAINING 'BRAM'

B> There are actually 130 streets in Holland containing my first name. But it
B> takes about 10/15 seconds before its returning the 130 rows with an IB_Query
B> set on active. Is there a way to check if the query is 100% optimized.

B> Could it go faster ?

B> Bram van der Voet / A&V Automatisering
B> bram@... <mailto:bram@...>
B> Glasbergenlaan 6
B> 2235 BP VALKENBURG ZH
B> tel 071 407 6956
B> fax 071 407 3939

Hi Bram.

An index can't help you at all when using CONTAINING, so I think 10-15
seconds is fairly OK on a table your size. if you used STARTING rather than
CONTAINING the index could be used, but then you would of course only get
those streets starting with Bram.

An alternative we've used here at the Norwegian Cancer Registry, is to
create some additional indexed fields (for names, not streets) containing
parts of the name. Let's say you added four fields street_part1,
street_part2, street_part3, street_part4 all defined as CHAR(5) and parsed
each street so that every part of the name got into these fields. In your
case, that would mean:

Street            Street_part1 Street_part2 Street_part3 Street_part4
Bram van der Voet Bram         van          der          Voet

(or maybe you would only store Bram and Voet, since I guess van der is
pretty common in the Netherlands, and a search for those words are next to
futile).

You could then modify your SQL to something like
SELECT STREET FROM POSTCODE
WHERE STREET CONTAINING 'BRAM'
  AND (STREET_PART1 STARTING 'BRAM' OR
       STREET_PART2 STARTING 'BRAM' OR
       STREET_PART3 STARTING 'BRAM' OR
       STREET_PART4 STARTING 'BRAM')

which would get all streets where Bram was the beginning of either of the
indexed fields - not quite containing, but you're normally interested in
searching for the beginning of a word in the street name, not something in
the middle.

The end result should be similar to your CONTAINING (all street but those
that doesn't start bram in any of the first four words of the street), but
it should be able to use indices which may speed things up a bit.

Set

At 11:46 05.12.2000 +0100, you wrote:
>>>>
With the help from the ibobjects lists I created a database/table with
about 450.000 records with all street names in the Netherlands.

CREATE TABLE "POSTCODE"
(
        "ID"      INT64         NOT NULL,
    "STREET"       CHAR(    50) CHARACTER SET NONE,
      "CITY"       CHAR(    50) CHARACTER SET NONE,
  "POSTCODE"       CHAR(     7) CHARACTER SET NONE,
  CONSTRAINT "PK_POSTCODE" PRIMARY KEY ("ID")
);

CREATE ASC INDEX "POSTCODE" ON "POSTCODE" ("POSTCODE");
CREATE ASC INDEX "STREET" ON "POSTCODE" ("STREET");
I created the following query :

SELECT STREET FROM POSTCODE WHERE STREET CONTAINING 'BRAM'

There are actually 130 streets in Holland containing my first name. But it
takes about 10/15 seconds before its returning the 130 rows with an
IB_Query set on active. Is there a way to check if the query is 100%
optimized.

Could it go faster ?

Bram van der Voet / A&V Automatisering
<mailto:bram@...>bram@...
Glasbergenlaan 6
2235 BP VALKENBURG ZH
tel 071 407 6956
fax 071 407 3939

eGroups Sponsor
<http://rd.yahoo.com/M=102308.1038796.2731130.908943/D=egroupmail/S=17000000
01:N/A=466330/?http://www.yahoo.com>Click Here!

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



<<<<

At 11:46 AM 05-12-00 +0100, you wrote:
>With the help from the ibobjects lists I created a database/table with
>about 450.000 records with all street names in the Netherlands.
>
>CREATE TABLE "POSTCODE"
>(
>        "ID"      INT64         NOT NULL,
>    "STREET"       CHAR(    50) CHARACTER SET NONE,
>      "CITY"       CHAR(    50) CHARACTER SET NONE,
>  "POSTCODE"       CHAR(     7) CHARACTER SET NONE,
>  CONSTRAINT "PK_POSTCODE" PRIMARY KEY ("ID")
>);
>
>CREATE ASC INDEX "POSTCODE" ON "POSTCODE" ("POSTCODE");
>CREATE ASC INDEX "STREET" ON "POSTCODE" ("STREET");
>I created the following query :
>
>SELECT STREET FROM POSTCODE WHERE STREET CONTAINING 'BRAM'
>
>There are actually 130 streets in Holland containing my first name. But it
>takes about 10/15 seconds before its returning the 130 rows with an
>IB_Query set on active. Is there a way to check if the query is 100% optimized.
>
>Could it go faster ?

Yes, it should be sub-second.  I think the problem is in the CONTAINING
clause - I always get confused about this but I *think* containing doesn't
use the index (or maybe CONTAINING does use it and STARTING WITH
doesn't).  Even if it does, it's still a lot of comparing to do 4
characters across potentially 50, not matched for case (46 * 450,000 compares).

Set the query up in the IB_WISQL and look at the plan that appears in the
monitor.  That will tell you what indexes are being used.

If you are still at the experimentation stage, add a proxy column for the
street that will get populated by a trigger and store the street name in
upper case.  You can populate the existing rows with

update postcode set PROXYSTREET=UPPER(STREET);

put an index on PROXYSTREET and try your CONTAINING clause on that.

Cheers,
H.
All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________

Are you using IB 6.0 with dialect 3 ?

[]s

  Carlos
  WarmBoot Informatica - http://www.warmboot.com.br
  Interbase-BR - http://www.interbase-br.com

RRE> I 'm having troubles with money fields. When I calculate medium prices in
RRE> StoredProc, the result is sometimes like 10.3453453. I want to store it
like
RRE> 10.35.
RRE> When I created field like NUMERIC(15,2), I thought that it would round the
RRE> number OK. But it seems that it only shows it rounded, calculation are
still
RRE> done with it's full value. I searched then for the round function, but
RRE> didn't find it.

RRE> There must be some easy solution to it. I can't imagine that I'm the only
RRE> one using Interbase for accounting software and that Interbase developers
RRE> didn't take money handling problems into account.

RRE> Riho-Rene Ellermaa
RRE> senior programmer
RRE> Hansabank


RRE> To unsubscribe from this group, send an email to:
RRE> ib-support-unsubscribe@egroups.com

I 'm having troubles with money fields. When I calculate medium prices in
StoredProc, the result is sometimes like 10.3453453. I want to store it like
10.35.
When I created field like NUMERIC(15,2), I thought that it would round the
number OK. But it seems that it only shows it rounded, calculation are still
done with it's full value. I searched then for the round function, but
didn't find it.

There must be some easy solution to it. I can't imagine that I'm the only
one using Interbase for accounting software and that Interbase developers
didn't take money handling problems into account.

Riho-Rene Ellermaa
senior programmer
Hansabank

JW> Have you tested this out? I would be interested in knowing if it works and
JW> what the down sides of it are.

No, I have no time yet :( My interest is the same as yours ;)

JW> I presume you would want to create the database using an alternative OWNER
JW> so that there would still be an avenue of administration. You might also
JW> want to look at that as yet another thing that needs to be locked down too.

Sure, you need to give ALL PRIVILEGES to another user before revoking
from SYSDBA.

- Carlos

> Since I didnt receive any answer from the IB gurus I had sent this
> message, I would like to know what you guy think about this :
>
>
> ---------------------------------------------
>
> I found a "solution" proposed by some people here in Brazil to "SOLVE" the
> problem regarding security problems in IB with the SYSDBA user. Following
> is a resume of what the guys proposed... I would like to hear from you
gurus
> if this is really a solution to the problem :
>
> Steps :
>
> 1) GRANT ALL on RDB$RELATIONS to SYSDBA
> 2) REVOKE ALL on RDB$RELATIONS from SYSDBA
> 3) Remove the rights of SYSDBA to select, insert and update the
> RDB$RELATIONS table, after that remove the SYSDBA rights (UPDATE and
> INSERT) to the RDB$USER_PRIVILEGES table
> 4) Now you have a database that can be copied to any machine and no SYSDBA
> will have any access to the database info/data.

Have you tested this out? I would be interested in knowing if it works and
what the down sides of it are.

I presume you would want to create the database using an alternative OWNER
so that there would still be an avenue of administration. You might also
want to look at that as yet another thing that needs to be locked down too.

FWIW,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

Hi people !

Since I didnt receive any answer from the IB gurus I had sent this
message, I would like to know what you guy think about this :


---------------------------------------------

I found a "solution" proposed by some people here in Brazil to "SOLVE" the
problem regarding security problems in IB with the SYSDBA user. Following
is a resume of what the guys proposed... I would like to hear from you gurus
if this is really a solution to the problem :

Steps :

1) GRANT ALL on RDB$RELATIONS to SYSDBA
2) REVOKE ALL on RDB$RELATIONS from SYSDBA
3) Remove the rights of SYSDBA to select, insert and update the
RDB$RELATIONS table, after that remove the SYSDBA rights (UPDATE and
INSERT) to the RDB$USER_PRIVILEGES table
4) Now you have a database that can be copied to any machine and no SYSDBA
will have any access to the database info/data.


[]s

  Carlos
  WarmBoot Informatica - http://www.warmboot.com.br
  Interbase-BR - http://www.interbase-br.com

Also Interactive Users means the user currently logged on, you might
try to specify a user instead of interactive..

--- In ib-support@egroups.com, "Jason Wharton" <jwharton@i...> wrote:
> You are probably using the local protocol instead of using TCP/IP
via
> localhost.
>
> Try TCP and see if that makes a difference.
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Andy Kallenbach" <andyk@m...>
> Newsgroups: mers.interbase.list
> To: "Interbase List" <Interbase@m...>
> Sent: Wednesday, November 15, 2000 1:03 PM
> Subject: DCom/Interbase/unavailable database
>
>
> > I am struggling with configuration issues on a DCOM automation
server I
> have
> > made. This automation server is setup to run under the Interactive
> identity.
> > The server connects to a local Interbase db, and works great as
long as I
> am
> > logged in. When noone is logged in, the server fails to connect
to the db,
> > reporting 'unavailable database'.
> >
> > I am running IB 5.6, its setup on our NT 4.0 Server (sp6) as a
service.
> > There are several databases on this server that run great, 24hrs
a day.
> > There is no problem connecting remotely to the database in
question, just
> > the automation server thats running while noone is logged in.
> >
> > Why is my Automation server receiving this error?
> >
> > Andy Kallenbach
> > Midwest Technical Specialists
> >

Hello, IBExpert User,

(german version at the end)
============================================================
Here is the weekly newsletter to everybody, who is interested
in the product IBExpert - the most Expert for InterBase.

What´s new?

1.) Today, we uploaded a new version 60 with a few bugfixes.
      http://www.ibexpert.com/download

November 29, 2000 (v. 1.0.0.60)
-Database registration form: Added some default options
(Default extract metadata file, default quick save directory,
default export directory).
-Fixed bug with initiating NOT NULL field after its creating.
-Fixed bug with renaming triggers in inplace trigger editor.
-Fixed bug with very slow navigating to the last record in
datasets.
-Some bugfixes and improvements in SQL Monitor.
-Now it is possible to turn on/off the main toolbar (Main Menu | View)
-SP Editor: Added Quick Save and Quick Load features.
-SP Editor: Now it is possible to analyse index using for
select, update and delete statements within stored procedure
-Some minor improvements and bugfixes...

2.) New PlugIn IB Datapump by Alexandre Poloziouk

Interbase DataPump allow you to pump data from any BDE/ODBC
sources (dBase, Paradox, MSSQL, Sybase, Oracle etc) into
Interbase databases easy, fast and painless. This programm
will help you to migrate from Interbase 5.xx and older
Interbase databases to the new Interbase 6.0 format.
You can also use it to pump data from one Interbase database
to another.
Download  http://www.ibexpert.com/download
For Support contact poloziouk@... or visit
the Homepage at http://www.geocities.com/poloziouk


--

============================================================
============================================================
Hier ist die wochentliche Newsletter fur alle IBExpert Anwender

Was ist neu?

1.) Heute haben wir eine neue Version 60 hochgeladen.
      http://www.ibexpert.com/download

      Die Bugfixes finden Sie oben

2.) Neues PlugIn IB Datapump von Alexandre Poloziouk


Die InterBase Datapump erlaubt eine Datenübertragung von jeder
BDE/ODBC Datenquelle. Auch für die Übertragung von IB5 auf IB6
(SQL Dialekt 3) ist die Datapump sehr hilfreich.

Ebenso ist die Übertragung zwischen verschiedenen InterBase
Datenbanken möglich.
Download  http://www.ibexpert.com/download
Für Support wenden Sie sich an poloziouk@... oder
besuchen Sie die Homepage http://www.geocities.com/poloziouk



Das war es zunächst einmal

Das IBExpert Team - ibexpert@...
============================================================
HK Software
Lange Straße 59

D-26122 Oldenburg
Germany

Telefon +49 441 2184770
Telefax +49 441 2184779



_______________________________________________
Interbase mailing list
Interbase@...
http://mers.com/mailman/listinfo/interbase

the documentation handicapper strikes again!

it seams that the required syntax is:

gfix [options] db_name -user NAME -password TEXT

Brian


> -----Original Message-----
> From: Brian Dunstan [mailto:bdunstan@...]
> Sent: Friday, 24 November 2000 2:30 PM
> To: 'ib-support@egroups.com'
> Subject: [ib-support] gfix command line
>
>
> Hi,
>
> I am going crazy here trying to get a simple gfix command
> line working. I
> have never used gfix before. Am I missing something here?
>
> gfix -user SYSDBA -password masterkey -shut -force 60
> c:\data\employee.gdb
>
> error message is "incompatible switch options"
>
> I am certain my syntax conforms to what is in the manual. I
> have checked and
> checked and checked....
>
> I am running gfix version WI-V5.6.0.29.
>
> TIA
>
> Brian
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> eGroups eLerts
> It's Easy. It's Fun. Best of All, it's Free!
> http://click.egroups.com/1/9698/0/_/_/_/975047414/
> --------------------------------------------------------------
> -------_->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>

Hi,

I am going crazy here trying to get a simple gfix command line working. I
have never used gfix before. Am I missing something here?

gfix -user SYSDBA -password masterkey -shut -force 60 c:\data\employee.gdb

error message is "incompatible switch options"

I am certain my syntax conforms to what is in the manual. I have checked and
checked and checked....

I am running gfix version WI-V5.6.0.29.

TIA

Brian

I shut down the database and restart it.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: "Victor Ivlichev" <ahasoft2000@...>
To: <ib-support@egroups.com>
Sent: Thursday, November 16, 2000 2:53 AM
Subject: [ib-support] How to kill user


> Hello!
>
> How to disattach user from IB server?
>
> Victor Ivlichev
> ahasoft2000@...
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>

Hello!

How to disattach user from IB server?

Victor Ivlichev
ahasoft2000@...

You are probably using the local protocol instead of using TCP/IP via
localhost.

Try TCP and see if that makes a difference.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: "Andy Kallenbach" <andyk@...>
Newsgroups: mers.interbase.list
To: "Interbase List" <Interbase@...>
Sent: Wednesday, November 15, 2000 1:03 PM
Subject: DCom/Interbase/unavailable database


> I am struggling with configuration issues on a DCOM automation server I
have
> made. This automation server is setup to run under the Interactive
identity.
> The server connects to a local Interbase db, and works great as long as I
am
> logged in. When noone is logged in, the server fails to connect to the db,
> reporting 'unavailable database'.
>
> I am running IB 5.6, its setup on our NT 4.0 Server (sp6) as a service.
> There are several databases on this server that run great, 24hrs a day.
> There is no problem connecting remotely to the database in question, just
> the automation server thats running while noone is logged in.
>
> Why is my Automation server receiving this error?
>
> Andy Kallenbach
> Midwest Technical Specialists
>

I just thought I would extend my greetings to those who are on this list and
to those who will be reading the archives of this list.

InterBase is going to be the database of the new millennium!

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com