I have a field name 'password' in a table X. During conversion from Access table,
the field name was automatically converted to 'passwordcol'. Looks like Firebird
doesn't allow 'password' as field name. I have an existing Java application with
more than a thousand classes, with complex relationships, and database tables mapped
as java objects. This makes it very difficult to change the field name in Java app
itself. What could be the best solution in such a situation? Any thoughts?

Thanks

--- ib-support@yahoogroups.com wrote:

>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
> ------------------------------------------------------------------------
>
> There are 25 messages in this issue.
>
> Topics in this digest:
>
> 1. Create user and role from store procedures
> From: "ebalvis2000" <ebalvis@...>
> 2. RE: Create user and role from store procedures
> From: "Martijn Tonies" <martijn@...>
> 3. DECLARE SECTION STATEMENT ERROR
> From: "Hellen Huang" <hellen@...>
> 4. RE: DECLARE SECTION STATEMENT ERROR
> From: "Martijn Tonies" <martijn@...>
> 5. Re: ODBC ERROR
> From: "Hellen Huang" <hellen@...>
> 6. case sensitive
> From: Jan Agermose <post@...>
> 7. RE: case sensitive
> From: "Martijn Tonies" <martijn@...>
> 8. Re: DECLARE SECTION STATEMENT ERROR
> From: "Hellen Huang" <hellen@...>
> 9. Re: DECLARE SECTION STATEMENT ERROR
> From: Daniel Rail <daniel@...>
> 10. RE: DECLARE SECTION STATEMENT ERROR
> From: "Martijn Tonies" <martijn@...>
> 11. Re: ODBC ERROR
> From: SD@...
> 12. RE: CBuilder 5 eval install
> From: Wes Barnett <wes@...>
> 13. Re: CBuilder 5 eval install
> From: lester@...
> 14. Interbase Security
> From: "Diego Gomez" <diego.gomez@...>
> 15. Re: ODBC ERROR
> From: "Hellen Huang" <hellen@...>
> 16. Re: ODBC ERROR
> From: Helen Borrie <helebor@...>
> 17. temporary tables
> From: Duilio Foschi <dedalus@...>
> 18. RE: Connect to Firebird from Windows
> From: "Martyn Shiner" <mjshiner@...>
> 19. Interesting problem, any ideas
> From: "Wilson, Fred" <fred.wilson@...>
> 20. Re: temporary tables
> From: Aage Johansen <aagjohan@...>
> 21. Could somebody pleeease help me??
> From: "Diego Gomez" <diego.gomez@...>
> 22. Re: CBuilder 5 eval install
> From: "csswa" <csswa@...>
> 23. Re: Could somebody pleeease help me??
> From: "Woody" <woody.tmw@...>
> 24. Re: temporary tables
> From: Frank Ingermann <frank@...>
> 25. Re: temporary tables
> From: Frank Ingermann <frank@...>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 1
> Date: Tue, 16 Apr 2002 09:09:04 -0000
> From: "ebalvis2000" <ebalvis@...>
> Subject: Create user and role from store procedures
>
> it is possible to create user and role from store procedures?
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 2
> Date: Tue, 16 Apr 2002 11:14:42 +0200
> From: "Martijn Tonies" <martijn@...>
> Subject: RE: Create user and role from store procedures
>
> Hi,
>
> first - creating a user from standard SQL isn't possible at all.
> second - using DDL (like creating a role, table, generator etc) isn't
> allowed from stored procedures.
>
>
> Hope this helps,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
>
>
> it is possible to create user and role from store procedures?
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 3
> Date: Tue, 16 Apr 2002 17:21:59 +0700
> From: "Hellen Huang" <hellen@...>
> Subject: DECLARE SECTION STATEMENT ERROR
>
> Hi All
>
> I have table named personpict contains two fields i.e:
> psno char(8)
> pspicture blob sub_type 0 segment size 80
>
> then I made a Stored Proc to insert row to personpict table as below :
>
> set term ^;
> create procedure SP_INSERT_TO_PERSONPICT
> (
> psno_cd char(8)
> )
> as
> begin
> begin declare section;
> based on personpict.pspicture blod_id;
> based on personpict.pspicture.segment blob_segment_buf;
> unsigned short blob_seg_len
> end declare section
>
> declare bc cursor for insert Blob pspicture into personpict;
>
> open bc into :blob_id
> blob_segment_len = strlen( blob_segment_buf)
>
> insert into bc values (:blob_segment_buf,:blob_segment_len)
> close bc
>
> insert into personpict(psno_cd,pspicture) values ('000140',:blob_id);
> end ^
> set term ;^
>
> But I confused how to pass bitmap image into stored proc's parameter and I still
> couldn't execute this Stored Procedure because there was an error occured :
>
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 7, char 10
> declare
>
> Could anyone tell me how to make the correct Stored Procedure?
>
> Thank's
> Hellen
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 4
> Date: Tue, 16 Apr 2002 12:34:00 +0200
> From: "Martijn Tonies" <martijn@...>
> Subject: RE: DECLARE SECTION STATEMENT ERROR
>
> Hellen,
>
> Where did you find this declare section stuff? Have you read the chapter
> Stored Procedure and Trigger Language in the Language Reference? I
> cannot find such a clause there...
>
> That probably explains your problem.
>
> As for making the correct procedure, read the above mentioned chapter
> and have a look at the examples in the chapter and the example database
> that comes with IB (EMPLOYEE).
>
>
> Hope this helps,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
>
>
> Hi All
>
> I have table named personpict contains two fields i.e:
> psno char(8)
> pspicture blob sub_type 0 segment size 80
>
> then I made a Stored Proc to insert row to personpict table as below :
>
> set term ^;
> create procedure SP_INSERT_TO_PERSONPICT
> (
> psno_cd char(8)
> )
> as
> begin
> begin declare section;
> based on personpict.pspicture blod_id;
> based on personpict.pspicture.segment blob_segment_buf;
> unsigned short blob_seg_len
> end declare section
>
> declare bc cursor for insert Blob pspicture into personpict;
>
> open bc into :blob_id
> blob_segment_len = strlen( blob_segment_buf)
>
> insert into bc values (:blob_segment_buf,:blob_segment_len)
> close bc
>
> insert into personpict(psno_cd,pspicture) values
> ('000140',:blob_id);
> end ^
> set term ;^
>
> But I confused how to pass bitmap image into stored proc's parameter and
> I still couldn't execute this Stored Procedure because there was an
> error occured :
>
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 7, char 10
> declare
>
> Could anyone tell me how to make the correct Stored Procedure?
>
> Thank's
> Hellen
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 5
> Date: Tue, 16 Apr 2002 17:24:04 +0700
> From: "Hellen Huang" <hellen@...>
> Subject: Re: ODBC ERROR
>
>
> I still got the same error, ping OK !
>
> TIA
> Hellen
>
>
> ----- Original Message -----
> From: <SD@...>
> To: <ib-support@yahoogroups.com>
> Sent: Friday, April 12, 2002 12:51 PM
> Subject: Re: [ib-support] ODBC ERROR
>
>
> > On 12 Apr 2002 at 11:08, Hellen Huang wrote:
> >
> > >Error - Unable to complete network request to host "192.168.80.10".
> > >Failed to establish a connection.
> > >unknown Win32 error 10061
> >
> > 10061 - server isn't listening.
> >
> > >How can I fix it..
> >
> > Probably, you should start the server. Or ask your system/network
> > administrator to investigate this case. Look into interbase.log to
> > find out server's reasons not to be runned.
> > Ping and netstat also are useful utilities.
> >
> > SY, Dimitry Sibiryakov.
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 6
> Date: 16 Apr 2002 13:25:59 +0200
> From: Jan Agermose <post@...>
> Subject: case sensitive
>
> I have been using Firebird for sometime now, and somehow come to the
> conviction that table and column names where case insensitive. They are
> not, it seems. Did I miss out on some important documentation notes?
> Shouldn't admin tools warn you that they change the case for you? Im
> using interclient to connect to the databases I've created. How can I
> change this "to uppercase" behavior of interclient?
>
> Jan Agermose
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 7
> Date: Tue, 16 Apr 2002 13:37:46 +0200
> From: "Martijn Tonies" <martijn@...>
> Subject: RE: case sensitive
>
> Hi,
>
> Everything (accept string matches in WHERE clauses) is case insensitive
> by default. That is, if you create them without double quotes, they're
> case insensitive.
>
> <advert>
> InterBase Workbench uses uppercase/non-quoted identifiers by default. It
> even warns you when using IB/FB keywords - they are allowed with quoted
> identifiers, but the application will warn you - or SQL92/99 keywords.
> Even if you select to use quoted identifiers, InterBase Workbench will
> warn you that you're about to create an object that you have to use
> quotes for.
> </advert>
>
> As for InterClient, I believe you have to have at least IC 2.0 to
> support quoted identifiers.
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
>
> I have been using Firebird for sometime now, and somehow come to the
> conviction that table and column names where case insensitive. They are
> not, it seems. Did I miss out on some important documentation notes?
> Shouldn't admin tools warn you that they change the case for you? Im
> using interclient to connect to the databases I've created. How can I
> change this "to uppercase" behavior of interclient?
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 8
> Date: Tue, 16 Apr 2002 18:10:09 +0700
> From: "Hellen Huang" <hellen@...>
> Subject: Re: DECLARE SECTION STATEMENT ERROR
>
> I found it in EmbedSQL Chapter 8 Working With BLOB Data page 199-200
>
> Regards
> Hellen
>
>
>
> ----- Original Message -----
> From: Martijn Tonies <martijn@...>
> To: <ib-support@yahoogroups.com>
> Sent: Tuesday, April 16, 2002 5:34 PM
> Subject: RE: [ib-support] DECLARE SECTION STATEMENT ERROR
>
>
> > Hellen,
> >
> > Where did you find this declare section stuff? Have you read the chapter
> > Stored Procedure and Trigger Language in the Language Reference? I
> > cannot find such a clause there...
> >
> > That probably explains your problem.
> >
> > As for making the correct procedure, read the above mentioned chapter
> > and have a look at the examples in the chapter and the example database
> > that comes with IB (EMPLOYEE).
> >
> >
> > Hope this helps,
> >
> > Martijn Tonies
> > InterBase Workbench - the developer tool for InterBase and Firebird
> > http://www.interbaseworkbench.com
> >
> >
> >
> > Hi All
> >
> > I have table named personpict contains two fields i.e:
> > psno char(8)
> > pspicture blob sub_type 0 segment size 80
> >
> > then I made a Stored Proc to insert row to personpict table as below :
> >
> > set term ^;
> > create procedure SP_INSERT_TO_PERSONPICT
> > (
> > psno_cd char(8)
> > )
> > as
> > begin
> > begin declare section;
> > based on personpict.pspicture blod_id;
> > based on personpict.pspicture.segment blob_segment_buf;
> > unsigned short blob_seg_len
> > end declare section
> >
> > declare bc cursor for insert Blob pspicture into personpict;
> >
> > open bc into :blob_id
> > blob_segment_len = strlen( blob_segment_buf)
> >
> > insert into bc values (:blob_segment_buf,:blob_segment_len)
> > close bc
> >
> > insert into personpict(psno_cd,pspicture) values
> > ('000140',:blob_id);
> > end ^
> > set term ;^
> >
> > But I confused how to pass bitmap image into stored proc's parameter and
> > I still couldn't execute this Stored Procedure because there was an
> > error occured :
> >
> > Dynamic SQL Error
> > SQL error code = -104
> > Token unknown - line 7, char 10
> > declare
> >
> > Could anyone tell me how to make the correct Stored Procedure?
> >
> > Thank's
> > Hellen
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 9
> Date: Tue, 16 Apr 2002 09:16:03 -0300
> From: Daniel Rail <daniel@...>
> Subject: Re: DECLARE SECTION STATEMENT ERROR
>
> At 16/04/2002 08:10 AM, you wrote:
> >I found it in EmbedSQL Chapter 8 Working With BLOB Data page 199-200
>
> This is meant for Embedded SQL, not Stored Procedures. Read the
> documentation that Martijn mentioned when it comes to Stored Procedures and
> Triggers.
>
> Have a nice day.
>
>
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.accramed.ca)
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 10
> Date: Tue, 16 Apr 2002 13:43:06 +0200
> From: "Martijn Tonies" <martijn@...>
> Subject: RE: DECLARE SECTION STATEMENT ERROR
>
> Hi Hellen,
>
> that explains it - Embedded SQL is not Stored Procedure & Trigger SQL.
> Check the Language Reference for the exact SP & Trigger language.
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
>
>
> I found it in EmbedSQL Chapter 8 Working With BLOB Data page 199-200
>
> Regards
> Hellen
>
>
>
>
>
> > Hellen,
> >
> > Where did you find this declare section stuff? Have you read the
> chapter
> > Stored Procedure and Trigger Language in the Language Reference? I
> > cannot find such a clause there...
> >
> > That probably explains your problem.
> >
> > As for making the correct procedure, read the above mentioned chapter
> > and have a look at the examples in the chapter and the example
> database
> > that comes with IB (EMPLOYEE).
> >
> >
> > Hope this helps,
> >
> > Martijn Tonies
> > InterBase Workbench - the developer tool for InterBase and Firebird
> > http://www.interbaseworkbench.com
> >
> >
> >
> > Hi All
> >
> > I have table named personpict contains two fields i.e:
> > psno char(8)
> > pspicture blob sub_type 0 segment size 80
> >
> > then I made a Stored Proc to insert row to personpict table as below
> :
> >
> > set term ^;
> > create procedure SP_INSERT_TO_PERSONPICT
> > (
> > psno_cd char(8)
> > )
> > as
> > begin
> > begin declare section;
> > based on personpict.pspicture blod_id;
> > based on personpict.pspicture.segment blob_segment_buf;
> > unsigned short blob_seg_len
> > end declare section
> >
> > declare bc cursor for insert Blob pspicture into personpict;
> >
> > open bc into :blob_id
> > blob_segment_len = strlen( blob_segment_buf)
> >
> > insert into bc values (:blob_segment_buf,:blob_segment_len)
> > close bc
> >
> > insert into personpict(psno_cd,pspicture) values
> > ('000140',:blob_id);
> > end ^
> > set term ;^
> >
> > But I confused how to pass bitmap image into stored proc's parameter
> and
> > I still couldn't execute this Stored Procedure because there was an
> > error occured :
> >
> > Dynamic SQL Error
> > SQL error code = -104
> > Token unknown - line 7, char 10
> > declare
> >
> > Could anyone tell me how to make the correct Stored Procedure?
> >
> > Thank's
> > Hellen
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 11
> Date: Tue, 16 Apr 2002 16:49:20 +0400
> From: SD@...
> Subject: Re: ODBC ERROR
>
> On 16 Apr 2002 at 17:24, Hellen Huang wrote:
>
> >I still got the same error, ping OK !
>
> What about netstat? Does it show you, that gds_db (3050) port on
> the server is listening? Is the IB server runned? Is there a line
> 'gds_db 3050/tcp' in the 'services' file? Have you ever tried the
> local connect or NetBEUI? Is there any network administrator or
> somebody with a good English and network understanding nearby? Have
> you ever read the "Operational guide"? Especially "Connection
> troubleshooting" section.
>
> SY, Dimitry Sibiryakov.
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 12
> Date: Tue, 16 Apr 2002 07:08:01 -0500
> From: Wes Barnett <wes@...>
> Subject: RE: CBuilder 5 eval install
>
> Helen,
> I realized I sent the post to the wrong news group too late. But, thank
> you for taking the time to answer any way.
>
> Wes Barnett
> Barnett Technology
>
>
> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Monday, April 15, 2002 9:57 PM
> To: Wes Barnett
> Cc: Jason Wharton
> Subject: Re: [ib-support] CBuilder 5 eval install
>
>
> At 09:38 PM 15-04-02 -0500, you wrote [to ib-support list]:
>
> >I am attempting to install the eval of IBO 4.2Gc with out success. If I am
> >right I need the C5_DCU.zip. Where can I get this, or when will it be
> >available? (Or am I way off base and don't need it to begin with?)
>
> Wes,
> You are right, for Builder you need more than is available in the
> download...
>
> First things first, IBObjects has its own support list (join at
> http://www.yahoogroups.com/community/ibobjects ). IBO questions are
> off-topic on ib-support, which is for Firebird and InterBase things.
>
> OK, now, you will need the full source code to compile the components for
> Builder. Please read the message below from Jason. Any problems, don't
> hesitate to post a question on the ibobjects list.- cheers, Helen
>
> Thank you for your interest in IB Objects. As requested this email contains
> the necessary URL to download the full source to the IB Objects
> component suite v.3.6Dk. It assumes that you have read, understand and
> agree to the terms of the Trustware license. If you have not read it in
> full yet, please
> proceed to my web-site and read it.
> http://www.ibobjects.com/ibo_trustware.html
>
> Download the full source of IBO v.4.2G, the 4.2Gc patch and (if you wish)
> the c-to-d test patch, from
> http://source.ibobjects.com/ibo4_reg_site/
>
> Please keep this URL confidential.
>
> Make sure you get the HowToInstall.txt from this URL too, as the
> installation procedure is different to that for the Eval version; and also
> pick up the TI sheet from the TechInfo page
> (http://www.ibobjects.com/TechInfo.html ).
>
> If you need support it is most appropriate that you use the public list
> server that I provide. You can sign up to my list
> server at http://www.yahoogroups.com/community/ibobjects .
>
> I also think you will greatly benefit from acquiring a copy of the Getting
> Started Guide that is offered through my site. You can get it immediately
> by entering in a secured credit card transaction for $29.50 and then
> download it electronically.
>
> So far everyone has had nothing but good things to say about it.
> For more information: http://www.ibobjects.com/ibo_gsg.html
>
> Make the most of using IBO!
> Thanks again for your interest and I wish you all the best in your
> programming endeavors!
>
> Regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
>
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 13
> Date: Tue, 16 Apr 2002 14:57:33 +0100
> From: lester@...
> Subject: Re: CBuilder 5 eval install
>
> Wes
>
> Cardinal sin number 1
>
> Please check what you have just posted to the list!!!!
>
> Helen eMailed you PRIVATELY.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 14
> Date: Tue, 16 Apr 2002 08:09:43 -0500
> From: "Diego Gomez" <diego.gomez@...>
> Subject: Interbase Security
>
> how can i know if an user uses only one database, and doesnt make another
> database with the same username, password and server name, and uses both of
> them in the same application?
>
> I would like to know how to recognize a database (instance) as the one an
> only the user can make, the only one than my application recognizes.
>
> By the way , my application is in Delphi 4, and im using interbase 5 for the
> Database.
>
> Can you help me?
>
> Thanks in advance
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 15
> Date: Tue, 16 Apr 2002 20:17:44 +0700
> From: "Hellen Huang" <hellen@...>
> Subject: Re: ODBC ERROR
>
>
> ----- Original Message -----
> From: <SD@...>
> To: <ib-support@yahoogroups.com>
> Sent: Tuesday, April 16, 2002 7:49 PM
> Subject: Re: [ib-support] ODBC ERROR
>
>
> > On 16 Apr 2002 at 17:24, Hellen Huang wrote:
> >
> > >I still got the same error, ping OK !
> >
> > What about netstat? Does it show you, that gds_db (3050) port on
> > the server is listening?
> yup, it's listening, i have try the comunication diagnostic, tcp/ip section
> it's say
> Found service 'GDS_DB' at port '3050'
> Connection established to host '192.168.80.10',
> on port 3050.
>
> >Is the IB server runned? Is there a line 'gds_db 3050/tcp' in the
> 'services' file?
> yest it's running, i only have this problem with windows me computer.
> >Have you ever tried the local connect or NetBEUI?
> i am not using this NetBeui protocol
> >Is there any network administrator or > somebody with a good English and
> network understanding nearby?
> i am the administrator
> > Have
> > you ever read the "Operational guide"? Especially "Connection
> > troubleshooting" section.
> never, where i can find it?
>
> regards
>
>
> Hellen
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 16
> Date: Wed, 17 Apr 2002 02:26:58 +1000
> From: Helen Borrie <helebor@...>
> Subject: Re: ODBC ERROR
>
> At 08:17 PM 16-04-02 +0700, Hellen Huang wrote:
>
> > > Have
> > > you ever read the "Operational guide"? Especially "Connection
> > > troubleshooting" section.
> >never, where i can find it?
>
> try
> ftp://ftpc.inprise.com/pub/interbase/techpubs/ib_b60_doc.zip
>
> cheers
> H
>
>
> All for Open and Open for All
> Firebird Open SQL Database � http://firebirdsql.org �
> http://users.tpg.com.au/helebor/
> _______________________________________________________
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 17
> Date: Tue, 16 Apr 2002 19:44:32 +0200
> From: Duilio Foschi <dedalus@...>
> Subject: temporary tables
>
> I have to issue a special query.
>
> The query is so complex that I cannot guess how to do it in one step.
>
> So I have decided to create a temporary table, fill it in several steps,
> then open and go thru it.
>
> As several users could be working on the same query, I build the name of
> the temporary table by adding a suffix and a number given by a generator.
> In this way I can be sure that the table name will be unique for every user.
>
> Are there better ways of using temporary tables in FB ?
>
> TIA
>
> Duilio Foschi
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 18
> Date: Tue, 16 Apr 2002 21:26:56 +0100
> From: "Martyn Shiner" <mjshiner@...>
> Subject: RE: Connect to Firebird from Windows
>
> Frank
>
> Thanks a lot for this. I'll download FB for windows and see what happens.
>
> Regards
>
> Martyn
>
> -----Original Message-----
> From: Frank Ingermann [mailto:frank@...]
> Sent: 15 April 2002 22:20
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Connect to Firebird from Windows
>
>
> Hi Martyn,
>
> Martyn Shiner wrote:
> >
> > Can I connect to a firebird database on a linux server (Mandrake 8.1) from
> a
> > windows pc with the client software from interbase 5 installed along with
> > Delphi 5?
> >
> > So far I'm not having any luck at all.
>
> you must make sure to use the correct gds32.dll that came with Firebird,
> otherwise it just won't work. (be careful if you still need the IB5 dll
> for IB5.6 databases! in that case you can set up a batch file that replaces
> the ib5 gds32.dll with the fb version in the %win%\System32 folder and
> vice versa)
>
> regards & hth,
> fingerman
>
> -------------------------------------------------------------------------
> when parsers parse, and compilers compile, then why don't objects object?
>
> fingerbirdy - fingerman's door to Firebird
> http://www.fingerbird.de
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 19
> Date: Tue, 16 Apr 2002 13:26:37 -0400
> From: "Wilson, Fred" <fred.wilson@...>
> Subject: Interesting problem, any ideas
>
> We've had an interesting problem at a site, and since, have been able to
> reproduce it here in the lab. We have some software running on multiple
> clients (NT4.0SP5) talking to an IB (5.6) database running on a server
> (NT4.0SP5, TCP/IP NP))..
> The software is running on 7 clients or so.
> We have other software (also talking to the same DB) running on another
> client, configured the same.
> At some point, we believe that the offending software is trashing (through
> poor threading design) one of the datamods. What we see is a "lockup" of all
> the clients. That is, the software freezes, unable to "talk" to the
> database. This even includes the other, somewhat non-related software,
> running on another client.
> Attempting to connect to the database, from a client machine, via WISQL, at
> this time, produces a "hung" WISQL application. That is it simply hangs with
> the SQL shaped cursor.
> From any of the clients, when in this state, you can open a command prompt
> and you *can* successfully ping the server box.
> IB does *not* appear to be dead. The CPU usage (IB) drops to 0% on the
> server.
> Opening WISQL on the server and attempting to connect via a local connection
> *IS* successful and the database appears fine.
> Opening WISQL on the server and attempting to connect via TCP/IP is *NOT*
> successful, it simply "hangs", as with the clients, with a SQL shaped
> cursor.
> The really interesting thing is that opening WISQL on another *server* box
> (this one running W2000, IB5.6) and attempting to connect to the database
> *is* successful.
> When the "offending" application, on one of the clients, is killed, via task
> manager, everthing is all of the sudden fine and working as expected.
> The only thing in the Interbase.log file are the (expected) 10054's from the
> application that was forcefully killed.
> Any ideas about what is going on?
> IB appears fine, the engine itself, based on the fact that I can connect
> locally via WISQL and do whatever I want in/to the database.
> It appears that some "driver" level network layer is "locked" until the
> offending (whatever the heck it's doing) application is killed.
>
>
> Best regards,
> Fred Wilson
> SE, Bell & Howell
> fred.wilson@...
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 20
> Date: Tue, 16 Apr 2002 22:35:44 +0200
> From: Aage Johansen <aagjohan@...>
> Subject: Re: temporary tables
>
> Duilio Foschi wrote:
> > ...
> > As several users could be working on the same query, I build the name of
> > the temporary table by adding a suffix and a number given by a generator.
> > In this way I can be sure that the table name will be unique for every user.
> > Are there better ways of using temporary tables in FB ?
>
>
> You could let all users use the same (permanent) table. Add a field -
> SESSION_ID - to the table. Let each session retrieve a session_id from a
> generator.
> You will find posts on this in the archives.
>
>
> Regards,
> Aage J.
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 21
> Date: Tue, 16 Apr 2002 16:05:23 -0500
> From: "Diego Gomez" <diego.gomez@...>
> Subject: Could somebody pleeease help me??
>
> how can i know if an user uses only one database, and doesnt make another
> database with the same username, password and server name, and uses both of
> them in the same application?
>
> I would like to know how to recognize a database (instance) as the one an
> only the user can make, the only one than my application recognizes.
>
> By the way , my application is in Delphi 4, and im using interbase 5 for
> the Database.
>
> Can you help me?
>
> Thanks in advance
>
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 22
> Date: Tue, 16 Apr 2002 14:02:39 -0000
> From: "csswa" <csswa@...>
> Subject: Re: CBuilder 5 eval install
>
>
> Just a reminder that users can delete their own posts at any time.
> The option will appear when you view your own posts. It won't affect
> any mailed digests etc but it will get something off the main list.
>
> Regards,
> Andrew Ferguson
>
>
> --- In ib-support@y..., lester@l... wrote:
> > Wes
> >
> > Cardinal sin number 1
> >
> > Please check what you have just posted to the list!!!!
> >
> > Helen eMailed you PRIVATELY.
> >
> > --
> > Lester Caine
> > -----------------------------
> > L.S.Caine Electronic Services
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 23
> Date: Tue, 16 Apr 2002 16:08:29 -0500
> From: "Woody" <woody.tmw@...>
> Subject: Re: Could somebody pleeease help me??
>
> From: "Diego Gomez" <diego.gomez@...>
> > how can i know if an user uses only one database, and doesnt make another
> > database with the same username, password and server name, and uses both
> of
> > them in the same application?
> >
> > I would like to know how to recognize a database (instance) as the one an
> > only the user can make, the only one than my application recognizes.
> >
> > By the way , my application is in Delphi 4, and im using interbase 5 for
> > the Database.
> >
>
> There are several things you could try, but you can't really guard against
> this for experienced users who know how to work with IB/FB directly. You
> could try adding a special table with an encrypted key in a field and test
> for this. Almost anything you do can be duplicated, though, by just backing
> up and restoring the database to a different name, then modifying it.
>
> Woody (TMW)
>
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 24
> Date: Tue, 16 Apr 2002 20:32:21 +0200
> From: Frank Ingermann <frank@...>
> Subject: Re: temporary tables
>
> Hi Duilio,
>
> Duilio Foschi wrote:
> > I have to issue a special query.
> >
> > The query is so complex that I cannot guess how to do it in one step.
> >
> > So I have decided to create a temporary table, fill it in several steps,
> > then open and go thru it.
>
> have you considered using a storedproc? it helps a lot in breaking up
> complex things into smaller parts, as you can e.g. use nested FOR SELECT
> loops when there are lots of joins involved.
>
> > As several users could be working on the same query, I build the name of
> > the temporary table by adding a suffix and a number given by a generator.
> > In this way I can be sure that the table name will be unique for every user.
> >
> > Are there better ways of using temporary tables in FB ?
>
> yes indeed - don't use temporary tables like this at all! You could use
> a *single* table and fill it temporarily, but it is imho not a good idea
> to constantly modify the metadata of your db as a normal app behaviour.
>
> In this single table you can take the generator and use it as a part of
> the primary key, so each user will have the "impression" it's his/her own
> temp table, while they are all really working on the same one. But you
> should really try the storedproc as it may elminiate the need for temp
> tables altogether.
>
> > TIA
> >
> > Duilio Foschi
>
> regards & hth,
> fingerman
>
> -------------------------------------------------------------------------
> when parsers parse, and compilers compile, then why don't objects object?
>
> fingerbirdy - fingerman's door to Firebird
> http://www.fingerbird.de
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
> Message: 25
> Date: Tue, 16 Apr 2002 21:13:41 +0200
> From: Frank Ingermann <frank@...>
> Subject: Re: temporary tables
>
> Hi Duilio, (sorry if this msg comes twice)
>
> Duilio Foschi wrote:
> > I have to issue a special query.
> >
> > The query is so complex that I cannot guess how to do it in one step.
> >
> > So I have decided to create a temporary table, fill it in several steps,
> > then open and go thru it.
>
> have you considered using a storedproc? it helps a lot in breaking up
> complex things into smaller parts, as you can e.g. use nested FOR SELECT
> loops when there are lots of joins involved.
>
> > As several users could be working on the same query, I build the name of
> > the temporary table by adding a suffix and a number given by a generator.
> > In this way I can be sure that the table name will be unique for every user.
> >
> > Are there better ways of using temporary tables in FB ?
>
> yes indeed - don't use temporary tables like this at all! You could use
> a *single* table and fill it temporarily, but it is imho not a good idea
> to constantly modify the metadata of your db as a normal app behaviour.
>
> In this single table you can take the generator and use it as a part of
> the primary key, so each user will have the "impression" it's his/her own
> temp table, while they are all really working on the same one. But you
> should really try the storedproc as it may elminiate the need for temp
> tables altogether.
>
> > TIA
> >
> > Duilio Foschi
>
> regards & hth,
> fingerman
>
> -------------------------------------------------------------------------
> when parsers parse, and compilers compile, then why don't objects object?
>
> fingerbirdy - fingerman's door to Firebird
> http://www.fingerbird.de
>
>
> ________________________________________________________________________
> ________________________________________________________________________
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/