Hi all :)

We have a table in our database that stores values as a
comma-separated
list. This idea probably originated from the Delphi TStringList
object.
However, since it is bad practice in terms of database design
principles, we
have created another table, where each of the values in the
comma-separated
list will be a separate record.

I now have to write a SP to copy data from the old table into
the new one.
In the old table, there's just one record that stores the
comma-separated
values. In the new table, I have to take out each value in the
comma-separated list and insert it into a new record.

Is there any way FB will support this processing, or do I need
to do it from
outside FB?

----- Original Message -----
From: <firebird-support@yahoogroups.com>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, January 06, 2004 03:32 AM
Subject: [firebird-support] Digest Number 1968


There are 25 messages in this issue.

Topics in this digest:

1. Undernet Channel for Firebird and InterBase....
From: "Rosello Bagundol" <lipax@...>
2. Local and remote DB, more FB instances
From: "Jiri Hoffmayer" <parsys@...>
3. Re: Local and remote DB, more FB instances
From: Helen Borrie <helebor@...>
4. Re: Local and remote DB, more FB instances
From: "Jiri Hoffmayer" <parsys@...>
5. Re: A Bunch of ibserver processes on Linux
From: Milan Babuskov <albis@...>
6. Connection refused on Server
From: "colincoleman2002" <yahoogroups@...>
7. Re: Connection refused on Server
From: Lester Caine <lester@...>
8. create an user with isql
From: "emisutil" <emiliano@...>
9. Excited about future of FB
From: "Lou" <lfeliz@...>
10. Re: create an user with isql
From: Emiliano Sutil <emiliano@...>
11. OT: Open Source Databases Gaining Favor
From: "dvanatta" <DVanatta@...>
12. RE: varchar(2048) holds 1012
From: kyle@...
13. RE: varchar(2048) holds 1012
From: kyle@...
14. Re: varchar(2048) holds 1012
From: kyle@...
15. Re: Connection refused on Server
From: "colincoleman2002" <yahoogroups@...>
16. Re: Connection refused on Server
From: Lester Caine <lester@...>
17. Re: create an user with isql
From: Milan Babuskov <albis@...>
18. Re: Connection refused on Server
From: "colincoleman2002" <yahoogroups@...>
19. Re: Re: Connection refused on Server
From: Milan Babuskov <albis@...>
20. Re: Connection refused on Server
From: "colincoleman2002" <yahoogroups@...>
21. Re: Re: Connection refused on Server
From: "Dan Wilson" <dwilson@...>
22. Re: Re: Connection refused on Server
From: Lester Caine <lester@...>
23. Firebird database access from ISAPI dll application
From: "Horacio Jamilis" <hjamilis@...>
24. Re: varchar(2048) holds 1012
From: Helen Borrie <helebor@...>
25. Re: Firebird database access from ISAPI dll application
From: Helen Borrie <helebor@...>


________________________________________________________________________
________________________________________________________________________

Message: 1
Date: Mon, 05 Jan 2004 11:31:20 -0000
From: "Rosello Bagundol" <lipax@...>
Subject: Undernet Channel for Firebird and InterBase....

I have created a channel on undernet (www.undernet.org &
www.cservice.undernet.org). The name of the online channel is
#interbase. This IRC (internet relay chat) channel is for all
InterBase & Firebird users and lovers. With this channel, people
using InterBase & Firebird will be united as one and will try to
help
each other out.

If you have the spare time and the knowledge to share and help
others
out then visit us at #interbase.

I am inviting all of you to join me there from time to time. My
online nickname is [philip] or ||ZeuS||. Just message me there
when
you are online using mIRC (wwww.mIRC.com) or using other IRC
clients
and always remember to use Undernet servers.

I hope this channel will help bring people using InterBase &
Firebird
closer. Thank you and have fun! If you have any questions...
Just
post a reply to this invitation.

See you there....



________________________________________________________________________
________________________________________________________________________

Message: 2
Date: Mon, 5 Jan 2004 12:48:48 +0100
From: "Jiri Hoffmayer" <parsys@...>
Subject: Local and remote DB, more FB instances

Hi,

1. How to tell FB1.5 RC7 to listen on some other port? I wish to
connect to
remote and local DB at once (using IBObjects).

2. And how can I run another FB instance (to avoid possible
instalation/version conflicts, for example to run FB1.0 and
FB1.5
simultaneously)

Please help, thanks.
Jiri



________________________________________________________________________
________________________________________________________________________

Message: 3
Date: Mon, 05 Jan 2004 23:05:34 +1100
From: Helen Borrie <helebor@...>
Subject: Re: Local and remote DB, more FB instances

At 12:48 PM 5/01/2004 +0100, you wrote:
>Hi,
>
>1. How to tell FB1.5 RC7 to listen on some other port? I wish
to connect to
>remote and local DB at once (using IBObjects).
>
>2. And how can I run another FB instance (to avoid possible
>instalation/version conflicts, for example to run FB1.0 and
FB1.5
>simultaneously)
>
>Please help, thanks.
>Jiri

If you can wait a few hours, the latest version of the release
notes
(v.107) in English should be available at www.ibphoenix.com for
download. There is a detailed new section on configuring the
service
port. Contact me privately if you can't wait and need a URL
sooner.

If you can wait a few more days, the same should be available in
Czech. :-)

/heLen



________________________________________________________________________
________________________________________________________________________

Message: 4
Date: Mon, 5 Jan 2004 14:18:40 +0100
From: "Jiri Hoffmayer" <parsys@...>
Subject: Re: Local and remote DB, more FB instances

Oh yeah, thanks fortunally I can wait a 'few hours' :-)
Ok, I'll check the release notes if I can find what I need.

Thank you
Jiri

>If you can wait a few hours, the latest version of the release
notes
>(v.107) in English should be available at www.ibphoenix.com for
>download. There is a detailed new section on configuring the
service
>port. Contact me privately if you can't wait and need a URL
sooner.

>If you can wait a few more days, the same should be available
in Czech.
:-)

>/heLen



________________________________________________________________________
________________________________________________________________________

Message: 5
Date: Mon, 05 Jan 2004 16:58:36 +0100
From: Milan Babuskov <albis@...>
Subject: Re: A Bunch of ibserver processes on Linux

Kris Balle Kristensen wrote:
> Env:
> Linux Redhat server 7.3 + upgrades
> JBoss 3.0.8 + patches
> Firebird SS version 1.0.3.972
> JBird JDBC-driver 1.0.1
>
> I just got a mail from our 1 line support explaining that one
of our
customers counted no less than 165 ibserver processes on the
Linux box,
which made it impossible to login to the system. We tried to
kill all these
processes (alll but 6 had the same parent process) and tried
login again to
no avail. Finally we rebooted the Linux box and everything went
back to
normal.
>
> Anybody seen this kind of behaviour on Linux before? If so how
to avoid
it?

It's probably the problem in your code or JBoss or JBird. I use
the same
Firebird version (with PHP clients) on Mandrake Linux for over a
year
and have had no such problems.

Probably so of the components don't release the connection. It
is also
possible that you have "inteligent" users who, when they don't
get fast
response, click the button again and again increasing the load
on the
server. If this is the case I recommend you Classic server.

> I seems like the CS version is the only version being upgraded
and
refactored from the firebird team. Is that right?

AFAIK, no.

> What is the difference between the CS & SS version of
Firebird? and what
version would you recommend for Redhat?

You can read about the differences here:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_ss_vs_classic

There isn't a one-fits-all version and it doesn't depend on the
distribution you're using, but rather on the problem at hand. If
you
have demands for both long-running queries and short
transaction, then
go with Classic. If you only have short-transactions and rare
long-running queries (monthly reports, etc.) use SuperServer.

> We have another problem regarding the connection management.
I'm not sure
about this one, but it looks like the driver is not cabable of
returning not
used connections back to the JBoss management pool. I read from
your
download page that a new version of the JDBC driver for CS 1.5
has arrived
where this issue should be fixed. Will this new version only
work with CS
1.5 or can I use with SS as well?

It seems to me that it is the same problem as those 165
connections. I
can't answer your final question, though, so I hope someone will
jump in.

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net




________________________________________________________________________
________________________________________________________________________

Message: 6
Date: Mon, 05 Jan 2004 15:54:49 -0000
From: "colincoleman2002" <yahoogroups@...>
Subject: Connection refused on Server

we have a sbs2003 server running firebird 1.03.972, and has been
> fine till we restarted it over xmas, now when we use
IBOdatabase
> connection or anything come to that we get connection refused.
I
am
> sure we had this before and just restarted the main server,
but we
> have done this 7 times now warm and cold boot as well, we have
> checked the obvious gds_db setting in the services file and it
looks
> fine, if I use IBExpert to test the connection either on the
server
> or any client we get the same error stating:-

> Failed to connect to host on port gds_db Error Num 10035.

> we are running ISA server ,but we always have been and and it
was
> all working before, the only help i can see is from Borland
that
> says it could be the Mcafee Anti virus , and this must be
> uninstalled from the server (VERY BAD IDEA I THINK).

> So does anyone know how to actually track down this problem
and
fix
> it ?





________________________________________________________________________
________________________________________________________________________

Message: 7
Date: Mon, 05 Jan 2004 16:30:20 +0000
From: Lester Caine <lester@...>
Subject: Re: Connection refused on Server

colincoleman2002 wrote:

> we have a sbs2003 server running firebird 1.03.972, and has
been
>fine till we restarted it over xmas, now when we use
IBOdatabase
>>connection or anything come to that we get connection refused.
I
> am
>>sure we had this before and just restarted the main server,
but we
>>have done this 7 times now warm and cold boot as well, we have
>>checked the obvious gds_db setting in the services file and it
> looks
>>fine, if I use IBExpert to test the connection either on the
> server
>>or any client we get the same error stating:-
>>Failed to connect to host on port gds_db Error Num 10035.
>>we are running ISA server ,but we always have been and and it
was
>>all working before, the only help i can see is from Borland
that
>>says it could be the Mcafee Anti virus , and this must be
>>uninstalled from the server (VERY BAD IDEA I THINK).
>
>>So does anyone know how to actually track down this problem
and

First - Is firebird actually running?
(ibserver.exe in process list )

Second - What happens if you just connect using IBExpert
without a host name?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services



________________________________________________________________________
________________________________________________________________________

Message: 8
Date: Mon, 05 Jan 2004 17:09:40 -0000
From: "emisutil" <emiliano@...>
Subject: create an user with isql

Hello,

I��m using Firebird 1.0.3 and I want to create an user from isql
but I
don��t know how I can get it.
A related question, in what system table does firebird store the
users?

Thanks

Emiliano Sutil



________________________________________________________________________
________________________________________________________________________

Message: 9
Date: Mon, 05 Jan 2004 17:13:21 -0000
From: "Lou" <lfeliz@...>
Subject: Excited about future of FB

Hello. This may be a bit off-topic here, but I have been
monitoring
the developers Newgroup for the past month and I am very excited
to
see Jim Starkey, the original developer of Interbase diving into
the
code base to create what he calls Project Vulcan. From what I
gather
he is rewriting/updating some very heavy duty pieces fo system
to
make FB happier in todays compute environment (Win32/Linux 32/64
bit,
single multi-threaded etc....)

If and when Vulcan is merged into Firebird, this beloved
database
will continue to hold up against the heavyweights and best of
all
still be Open source.

Of course I am sure the changes and improvements in architecture
may
mean a few heartaches, but then that is the nature of change.
Someone once told me when it comes to change : Adapt, Migrate or
Die!

Anyway, looking forward to a very great new year.

- Lou

p.s. Support the Firebird Foundation. Goto
http://firebird.sourceforge.net/ff/foundation/index.php?
id=contributions.html#donation and make a donation. Every dollar
helps make Firebird a better database.



________________________________________________________________________
________________________________________________________________________

Message: 10
Date: Mon, 05 Jan 2004 18:35:13 +0100
From: Emiliano Sutil <emiliano@...>
Subject: Re: create an user with isql

Tim Benest wrote:

> On 05 January 2004 17:09 +0000 emisutil <emiliano@...>
wrote to
> firebird-support@yahoogroups.com on the subject of
[firebird-support]
> create an user with isql, which I reply with comments
interspersed
> below on Mon, 05 Jan 2004 17:14:30 +0000:
>
>
>
> Don't use ISQL, use GSEC
>
> gsec -user sysdba -password masterkey -add xxxxxx -pw yyyyyy
>
ok, this solve my problem for now.
but, I�m writting an application in delphi and I want to create
the
users using SQL, is it possible or I need
third-party components?

--
Emiliano Sutil Garc�a






________________________________________________________________________
________________________________________________________________________

Message: 11
Date: Mon, 05 Jan 2004 17:42:19 -0000
From: "dvanatta" <DVanatta@...>
Subject: OT: Open Source Databases Gaining Favor

--- In firebird-support@yahoogroups.com, "Lou" <lfeliz@y...>
wrote:
> Hello. This may be a bit off-topic here, but I have been
monitoring
> the developers Newgroup for the past month and I am very
excited
to
> see Jim Starkey, the original developer of Interbase diving
into
the
> code base to create what he calls Project Vulcan.

I too am enjoying watching the "Jim threads" as I like to call
it.
It has been an interesting lesson in software design for those
of us
who only create business apps.

Here is an article from CNET today talking about the future of
open
source databases: http://news.com.com/2100-7344_3-5134836.html?
tag=nefd_top.




________________________________________________________________________
________________________________________________________________________

Message: 12
Date: Mon, 5 Jan 2004 10:15:00 -0800
From: kyle@...
Subject: RE: varchar(2048) holds 1012

Alan,

Regarding the character set, I must be using the default, since
I don't
believe I have
explicitly set it or changed it in the last few years.

Thanks,

Kyle

On 1 Jan 2004, at 12:08, Alan McDonald wrote:

> > I have a varchar(2048) that holds only about 1012 actual
> > characters. If I try to insert
> > more than that It fails with:
> >
> > First Err: arithmetic exception, numeric overflow, or string
truncation
> > SqlCode: Arithmetic overflow or division by zero has
occurred.
> >
> > The particular string consisted of numerals
"12345670123etc", but
> > of course that
> > should not make any difference.
> >
> > Is this to be expected? I am pretty sure that I have other
> > tables with varchar(2048)
> > which will allow inserts of 2000 chars. Or am I losing my
mind :)
> >
> > Thanks,
> >
> > Kyle
>
> What character set are you using? depending on which one, you
may not get
> anywhere near the char size of the field. If NONE, then you
should get all
> 2048
> Alan
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>
>



http://pearz.com - A new whole-person approach to online dating


________________________________________________________________________
________________________________________________________________________

Message: 13
Date: Mon, 5 Jan 2004 10:19:15 -0800
From: kyle@...
Subject: RE: varchar(2048) holds 1012

Hi,

On a recent restore, I tried a page size of 8192. Could that be
the
cuplprit?

I believe I have always used pages size 4096 previously, but it
could be
even less.

Thanks,

Kyle

On 1 Jan 2004, at 12:41, Alan McDonald wrote:

> > >What character set are you using? depending on which one,
you may not
get
> > >anywhere near the char size of the field. If NONE, then you
> > should get all
> > >2048
> > >Alan
> > >
> > >
> > >
> > This is also a function of the page size (from what I
remember).
> >
> > --
> > Thomas Miller
> > Delphi Client/Server Certified Developer
> > BSS Accounting & Distribution Software
> > BSS Enterprise Accounting FrameWork
>
> That's true - I keep forgetting that.. a default page size of
1024 is so
> useless I sort of think the default should be changed to say
4096 as a
> minimum
> Alan
>
>

http://pearz.com - A new whole-person approach to online dating


________________________________________________________________________
________________________________________________________________________

Message: 14
Date: Mon, 5 Jan 2004 10:20:32 -0800
From: kyle@...
Subject: Re: varchar(2048) holds 1012

Hi,

I did recently do a restore with a page size of 8192, and had
always used a
smaller
page size before. Alan suggesteed the possibility of a problem
there, and
that does co-
incide with my experience. I can do a restore with the smaller
page size
later and see
if there is a difference.

Regarding monitoring, I have a simple log in my application (in
C++) and
check the
CString length before sending, as well as printing out the query
string, its
detected
length, and other related data. All seems normal. But I'm not
sure what
monitoring tool
you might be referring to, it may tell more?

Thanks,

Kyle


On 1 Jan 2004, at 12:35, Helen Borrie wrote:

> At 04:06 PM 31/12/2003 -0800, you wrote:
> >Hello,
> >
> >Using FB 1.0
> >
> >I have a varchar(2048) that holds only about 1012 actual
characters. If I
> >try to insert
> >more than that It fails with:
> >
> >First Err: arithmetic exception, numeric overflow, or string
truncation
> >SqlCode: Arithmetic overflow or division by zero has
occurred.
> >
> >The particular string consisted of numerals "12345670123etc",
but of
> >course that
> >should not make any difference.
> >
> >Is this to be expected? I am pretty sure that I have other
tables with
> >varchar(2048)
> >which will allow inserts of 2000 chars. Or am I losing my
mind :)
>
> Varchar(2048) should accept 2048 characters and overflow at
2049 or
> higher. You should not be getting an arithmetic error on
*storing* a
> varchar. Have you tried explicitly casting your values as
varchar(2048)?
>
> Are you certain that you are not passing an expression
(function call,
> etc.) that might be causing the exception? The ib_udf string
functions
> have a known bug that none of them will accept strings longer
than 80
> bytes, making them useless for processing longer strings.
>
> It seems this problem would benefit from putting a SQL monitor
on the
> interface, to see what the application is passing.
>
> /heLen
>
>

http://pearz.com - A new whole-person approach to online dating


________________________________________________________________________
________________________________________________________________________

Message: 15
Date: Mon, 05 Jan 2004 16:52:20 -0000
From: "colincoleman2002" <yahoogroups@...>
Subject: Re: Connection refused on Server

If I connect with Ibexperts using a local connection Eg
d:\data\database.gdb it works fine, if i try to connect
using "LOCALHOST" as the server name it fails to connect, the
same
as if i connect using the construct
MYSERVER:D:\data\database.gdb

As the system has working fine (ON TCP OVER LOCAL NETWORK) for
about
4 weeks now, i suspect the answer is NOT one of the following

**Firebird will not work uder windows 2003 serever
**Will not work under ISA server
**Will not work when a Virus protection program is in the
building
**Will not work if its raining outside.

I have just run netstat -a and cant see the gds_db line in the
file
anymore where it was this morning, but that didnt seem to make
any
difference as when it was there it still didnt connect over the
TCP
connection.

Are there any debugging tools available to trace what maybe
happening ?







--- In firebird-support@yahoogroups.com, Lester Caine
<lester@l...>
wrote:
> colincoleman2002 wrote:
>
> > we have a sbs2003 server running firebird 1.03.972, and has
been
> >fine till we restarted it over xmas, now when we use
IBOdatabase
> >>connection or anything come to that we get connection
refused. I
> > am
> >>sure we had this before and just restarted the main server,
but
we
> >>have done this 7 times now warm and cold boot as well, we
have
> >>checked the obvious gds_db setting in the services file and
it
> > looks
> >>fine, if I use IBExpert to test the connection either on the
> > server
> >>or any client we get the same error stating:-
> >>Failed to connect to host on port gds_db Error Num 10035.
> >>we are running ISA server ,but we always have been and and
it
was
> >>all working before, the only help i can see is from Borland
that
> >>says it could be the Mcafee Anti virus , and this must be
> >>uninstalled from the server (VERY BAD IDEA I THINK).
> >
> >>So does anyone know how to actually track down this problem
and
>
> First - Is firebird actually running?
> (ibserver.exe in process list )
>
> Second - What happens if you just connect using IBExpert
> without a host name?
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services




________________________________________________________________________
________________________________________________________________________

Message: 16
Date: Mon, 05 Jan 2004 19:07:35 +0000
From: Lester Caine <lester@...>
Subject: Re: Connection refused on Server

colincoleman2002 wrote:

> Sorry Lester,
>
> Did you get my reply?,

Trying to juggle a couple of problem machines myself :)

From your notes - the problem is with TCP/IP.
I've seen something similar myself, but usually when the
network is playing up. Since I use Wireless links for some
stuff, problems on these can stop TCP/IP working.

I can't remember the easy way to check, but I would probably
be looking to the network card or cabling. Can you access
the machine over the network properly?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services



________________________________________________________________________
________________________________________________________________________

Message: 17
Date: Mon, 05 Jan 2004 20:09:46 +0100
From: Milan Babuskov <albis@...>
Subject: Re: create an user with isql

Emiliano Sutil wrote:
> ok, this solve my problem for now.
> but, I�m writting an application in delphi and I want to
create the
> users using SQL, is it possible or I need
> third-party components?

You need to use Service API.

There are few options:
1. Use a 3rd party component. Which components do you have in
Delphi
now? Perhaps you already have it.

2. Create "gsec" command line and spawn process to do it.

3. Use Firebird API. I'm not sure if you can do this from
Delphi, since
it is in C.

HTH
--
Milan Babuskov
http://fbexport.sourceforge.net




________________________________________________________________________
________________________________________________________________________

Message: 18
Date: Mon, 05 Jan 2004 19:25:33 -0000
From: "colincoleman2002" <yahoogroups@...>
Subject: Re: Connection refused on Server

Yes this is the main company server and nobody has any problems,
Except little ol'e me trying to get Firebird to service requests
over TCP on port 3050.

Evrything else works all the VPN clints are connecting from
outside
to in, and visa versa, web servers are running 100%, the only
thing
that aint working is remote connections INTO the server on port
3050
to firebird.

Can I use some "Telnet" type program to try and ask the server
if
firebird is awake and listening.

If i run netstat -a now it has a line that says

TCP cbl01:1080 cbl01.cbl.local:0 LISTENING
TCP cbl01:1745 cbl01.cbl.local:0 LISTENING
TCP cbl01:3025 cbl01.cbl.local:ldap
CLOSE_WAIT
TCP cbl01:3048 cbl01.cbl.local:ldap
ESTABLISHED
TCP cbl01:3050 cbl01.cbl.local:1025
ESTABLISHED
TCP cbl01:3051 cbl01.cbl.local:1025
ESTABLISHED
TCP cbl01:3064 cbl01.cbl.local:3268
ESTABLISHED
TCP cbl01:3065 cbl01.cbl.local:ldap
ESTABLISHED

This looks like its actually got a connection from someone and
is
running, am i correct?



--- In firebird-support@yahoogroups.com, Lester Caine
<lester@l...>
wrote:
> colincoleman2002 wrote:
>
> > Sorry Lester,
> >
> > Did you get my reply?,
>
> Trying to juggle a couple of problem machines myself :)
>
> From your notes - the problem is with TCP/IP.
> I've seen something similar myself, but usually when the
> network is playing up. Since I use Wireless links for some
> stuff, problems on these can stop TCP/IP working.
>
> I can't remember the easy way to check, but I would probably
> be looking to the network card or cabling. Can you access
> the machine over the network properly?
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services




________________________________________________________________________
________________________________________________________________________

Message: 19
Date: Mon, 05 Jan 2004 21:02:00 +0100
From: Milan Babuskov <albis@...>
Subject: Re: Re: Connection refused on Server

colincoleman2002 wrote:
> Yes this is the main company server and nobody has any
problems,
> Except little ol'e me trying to get Firebird to service
requests
> over TCP on port 3050.
>
> Evrything else works all the VPN clints are connecting from
outside
> to in, and visa versa, web servers are running 100%, the only
thing
> that aint working is remote connections INTO the server on
port 3050
> to firebird.

Is there perhaps some firewall in between. It can ban any
comunication
on 3050 port without you knowing it. You can try running apache
or some
other server on 3050 to check, or by running firebird on some
"legal"
port like 80.

> Can I use some "Telnet" type program to try and ask the server
if
> firebird is awake and listening.

Yes. It should either refuse the connection or let you in:
telnet host 3050

> If i run netstat -a now it has a line that says
>
> TCP cbl01:1080 cbl01.cbl.local:0
LISTENING
> TCP cbl01:1745 cbl01.cbl.local:0
LISTENING
> TCP cbl01:3025 cbl01.cbl.local:ldap
CLOSE_WAIT
> TCP cbl01:3048 cbl01.cbl.local:ldap
ESTABLISHED
> TCP cbl01:3050 cbl01.cbl.local:1025
ESTABLISHED

> This looks like its actually got a connection from someone and
is
> running, am i correct?

Yes.

--
Milan Babuskov
http://fbexport.sourceforge.net




________________________________________________________________________
________________________________________________________________________

Message: 20
Date: Mon, 05 Jan 2004 21:02:45 -0000
From: "colincoleman2002" <yahoogroups@...>
Subject: Re: Connection refused on Server

Hi

As nobody has access to the server and sneaked a Firewall onto
the
server i guess that aint the problem, Apart from the fact that
the
server is running ISA server (Firewall) and always has beenThe
telnet test failed with

Z:\>telnet 192.168.17.2 3050
Connecting To 192.168.17.2...Could not open connection to the
host,
on port 3050
: Connect failed

are there any tools to test a connection without Firebird ?







________________________________________________________________________
________________________________________________________________________

Message: 21
Date: Mon, 05 Jan 2004 13:19:10 -0800
From: "Dan Wilson" <dwilson@...>
Subject: Re: Re: Connection refused on Server

If I have understood your problem, you have the following
situation:

1. The server was working fine until it was rebooted.
2. Since the reboot, you are unable to connect to port 3050.
3. The server is running the ISA server software as a firewall.

Are you absolutely certain that no configuration changes to the
firewall
were made before the last reboot? Were any updates or upgrades
applied? It
sure sounds from everything you have said as if the ISA server
is blocking
communication attempts on that port (even telnet failed).

Can you shut down the firebird server and enable some other
(web?) server to
use port 3050 temporarily, then see if you can connect to that?

Regards,

Dan.


*********** REPLY SEPARATOR ***********

On 1/5/2004 at 9:02 PM colincoleman2002 wrote:

Hi

As nobody has access to the server and sneaked a Firewall onto
the
server i guess that aint the problem, Apart from the fact that
the
server is running ISA server (Firewall) and always has beenThe
telnet test failed with

Z:\>telnet 192.168.17.2 3050
Connecting To 192.168.17.2...Could not open connection to the
host,
on port 3050
: Connect failed

are there any tools to test a connection without Firebird ?








Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

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

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/







________________________________________________________________________
________________________________________________________________________

Message: 22
Date: Mon, 05 Jan 2004 21:19:51 +0000
From: Lester Caine <lester@...>
Subject: Re: Re: Connection refused on Server

> are there any tools to test a connection without Firebird ?

http://www.ntutility.com/freeware.html
ActivePorts

Think that will tell you what is on port 3050, and what
other ports are running.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services



________________________________________________________________________
________________________________________________________________________

Message: 23
Date: Mon, 5 Jan 2004 18:25:27 -0300
From: "Horacio Jamilis" <hjamilis@...>
Subject: Firebird database access from ISAPI dll application

Hi,

I am trying without success to connect to a database with the
"local"
protocol (in fact without protocol), in an ISAPI dll application
without
success.

The error code I get is:

unavailable database
Unsuccessful execution caused by an unavailable resource.
Error Code: 55

What does it means?

If I append "localhost:" to the begining of the database
connection string
the application works properly but I want to use it with the
firebird
embedded (because I don't want to install firebird in that
server), and it
does not support tcp/ip connections.

Any help is appreciated.

Horacio


[Non-text portions of this message have been removed]



________________________________________________________________________
________________________________________________________________________

Message: 24
Date: Tue, 06 Jan 2004 08:47:10 +1100
From: Helen Borrie <helebor@...>
Subject: Re: varchar(2048) holds 1012

At 10:20 AM 5/01/2004 -0800, you wrote:
>Hi,
>
>I did recently do a restore with a page size of 8192, and had
always used
>a smaller
>page size before. Alan suggesteed the possibility of a problem
there, and
>that does co-
>incide with my experience. I can do a restore with the smaller
page size
>later and see
>if there is a difference.

Consider that theory absolute rubbish. A too-small page size
can cause
performance problems. A too-big page size can cause performance
problems. 8192 is about right for normal usage on modern
systems. Having
an unsuitable page size doesn't affect data. You have an
application bug
somewhere.


>Regarding monitoring, I have a simple log in my application (in
C++) and
>check the
>CString length before sending, as well as printing out the
query string,
>its detected
>length, and other related data. All seems normal. But I'm not
sure what
>monitoring tool
>you might be referring to, it may tell more?

An SQL monitoring tool, as found in nearly all GUI admin
utilities and as a
component in IB Objects and some other dao component suites. I
think ODBC
on Windows also has one.

>On 1 Jan 2004, at 12:35, Helen Borrie wrote:
>
> > At 04:06 PM 31/12/2003 -0800, you wrote:
> > >Using FB 1.0
> > >
> > >I have a varchar(2048) that holds only about 1012 actual
characters. If
I
> > >try to insert
> > >more than that It fails with:
> > >
> > >First Err: arithmetic exception, numeric overflow, or
string truncation
> > >SqlCode: Arithmetic overflow or division by zero has
occurred.
> > >
> > >The particular string consisted of numerals
"12345670123etc", but of
> > >course that
> > >should not make any difference.

That depends. If your application is receiving data into
variants and then
passing the variant to a varchar without casting it, then the
engine first
has to cast a string of numbers from its assumed type (here it
would be
decimal(18,0)) to string. If the string of number appeared to
it as a
beyond-range number, then you would get exactly the exceptions
you report.

Note also my previous comment:

> >
> > Are you certain that you are not passing an expression
(function call,
> > etc.) that might be causing the exception? The ib_udf
string functions
> > have a known bug that none of them will accept strings
longer than 80
> > bytes, making them useless for processing longer strings.
> >

Btw, it has now been established by concensus in firebird-devel
that the
UDF string length "bug" isn't a bug, but is "as designed". This
means
that, if there is a string UDF in this picture, you need to drop
it and
redeclare it with a CSTRING(N) input that is long enough to
handle the
input you are passing to it.

/heLen



________________________________________________________________________
________________________________________________________________________

Message: 25
Date: Tue, 06 Jan 2004 09:02:12 +1100
From: Helen Borrie <helebor@...>
Subject: Re: Firebird database access from ISAPI dll application

At 06:25 PM 5/01/2004 -0300, you wrote:
>Hi,
>
>I am trying without success to connect to a database with the
"local"
>protocol (in fact without protocol), in an ISAPI dll
application without
>success.
>
>The error code I get is:
>
>unavailable database
>Unsuccessful execution caused by an unavailable resource.
>Error Code: 55
>
>What does it means?

If you are using the embedded client, then it means that an
external client
already has the database file open. With embedded you must be
able to
obtain exclusive access to the file in order to connect.


>If I append "localhost:" to the begining of the database
connection string
>the application works properly but I want to use it with the
firebird
>embedded (because I don't want to install firebird in that
server), and it
>does not support tcp/ip connections.

This merely indicates that you have a full server running on the
machine
and you are able to make a normal tcp/ip local loopback
connection via the
"natural" fbclient.dll. No surprises there.

Shut down all other connections to the database before you try
to connect
through fbembed.dll (which must be located in the application
directory and
renamed to fbclient.dll).

/heLen





________________________________________________________________________
________________________________________________________________________




------------------------------------------------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

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

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
------------------------------------------------------------------------




__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus