Temporary tables are generally (but not always) a sign of a bad process.
Migration from a BDE/ISAM design to an RDBMS design is more involved
than putting the RDBMS tables behind the old structures.

If you are generating temporary tables, they should be generated using
server resources only. Only process in your app what you actually need
to bring back from the server.

On Tue, 2005-06-21 at 10:34 -0300, Gustavo wrote:
> Adam:
>
> I use this local temporary database because I am migrating an application which used dBase tables with BDE and it uses temporary tables. I also think that using it I reduces the wire traffic when processing the data. Is it true or I am wrong?
>
> I am getting temporary directory using the API function GetTempPath.
>
>
> I did what you suggest and it worked fine. I extract fbembed.dll from Firebird-1.5.1.4481_embed_win32.zip, I rename it gds32.dll and copied it into the folder of my application. I also copied the files
> ib_util.dll
> firebird.msg
> intl\fbintl.dll
> udf\fbudf.dll
> udf\ib_udf.dll
>
> But I'm not sure if firebird.msg is needed. Is it needed?
>
> I also don't know if I have to copy firebird.conf. Is this file necessary in the client PC2?
>
> Now I have only one problem (which I know :-) None of my PCs (neither PC1 nor PC2) are connected to internet. They are only in a LAN. When my application starts in PC2, when it executes the command IBDataBase1.Connected:=True, with DataBaseName property set to PC1:DataBaseAlias1 to conect to the first database in PC1, it opens the windows dialog to connect to a Dial Up conection. I press "Cancel" and then it conects without any problem to the first database in PC1 and to the others (it conects to 4 databases in PC1). It seems as it first tries to look for the host PC1 in internet and if it doesn't find it, it looks for it in the LAN.
>
> Can I avoid this Windows dialog in any way?
>
> Thanks again
>
> Gustavo
> ----- Mensaje original -----
> De: Adam
> Para: firebird-support@yahoogroups.com
> Enviado: Lunes, 20 de Junio de 2005 23:45
> Asunto: [firebird-support] Re: Client in FireBird
>
>
> --- In firebird-support@yahoogroups.com, "Gustavo" <gusm@d...> wrote:
> > Adam:
> >
> > Thank you very much for your answer.
> >
> > I renamed fbclient.dll to gds32.dll and now the application
> starts OK in PC2 and connects OK to database in PC1:DataBaseAlias1.
> >
> > Now I have another problem. When it starts, the application
> creates a local temporary database in Windows Temp directory. This is
> done with an IBX TIBDataBase component with
> C:\Windows\Temp\TempDataBase0.FDB in its DataBaseName property and
> using the method CreateDataBase. In PC1 (the server) this works fine
> (obviously using the right Windows Temp directory) but in PC2 (the
> client with Windows 98), the CreateDataBase fails and gets the
> message "unavailable database".
> >
> > Do you (or someone else) know what's the reason and how can I
> solve it?
>
> Hello Gustavo,
>
> What are you trying to achieve with this local temporary database? Is
> it about reducing over the wire traffic when processing the data, or
> is it a legacy decision on how it used to have to be done using
> whatever engine you used to use?
>
> Create Database is a command that must be issued to a computer
> running a FB Server. I doubt this is an OS issue, but rather a
> concept issue.
>
> If you do actually need a local temporary database, then consider
> using the embedded version of FB. Download it (then rename it to
> gds32.dll in place of the one that you currently use, and then you
> should be able to create the database). I would look up the $TEMP
> environment variable rather than searching for windows\temp though,
> because not all windows versions use c:\windows\temp by default (nt /
> 2k for a start)
>
> Adam
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> ------------------------------------------------------------------------------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>