Subject Re: Database setup, memory errors when starting application, Firebird DB config.
Author Adam
--- In firebird-support@yahoogroups.com, Gaurav Sood
<sood.gaurav@g...> wrote:
>
> Dear Members,
>
> I am attempting to update a 16 bit version of a Delphi software (to
32bit),
> that may potentially be setup to access an Interbase Database that is a
> 16bit database. I plan to migrate the old database to the current
release of
> Firebird 1.50. Currently I have access to several development
codebases of
> the software. When I attempt to run the software, I get the following
> errors. The code doesn't compile when I try to build it, and I am a
not sure
> where the parameters are stored for the various errors, or how I should
> attempt to fix the code so it compiles.
>
> If any help can be provided it would be highly appreciated.
>
> 1. Whe opening the .exe file for the software I get this error:
> >"File name is too long for a Paradox version 5.0 Table
> >Permission denied
> >File F:\....\C..\database\inventry .db"
>
> What is the Paradox table ?

Argh, an old desktop database, google for BDE. Using the old 8.3
rules, I am guessing it doesn't like that space in the filename.
Switching from Paradox to Firebird halved the support queries even
after quadrupling the install-base.

>
>
> 2. This error occurs when the GUI opens up and I attempt to
configure some
> options within the interface:
> >"Unknown Database
> >Unable complete network request to host "IB_SERVER"
> >Failed to locate host machine.
> >The specified name was not found in the General SQL error.
> >hosts file or Domain Name Services.
> >Alias: CASALA."
>
> When I open the 'Database Editor' from the GUI representation of this
> database, I find the following parameter:
> "SERVER NAME=IB_SERVER:/PATH/DATABASE.GDB"
>

Is this the same database? This looks to me like an interbase
database, but Paradox is not interbase.

>
> 3. Open Database Command leads to error as follows:
> "Access violation at address 005150SE in module "C.....exe". Read of
address
> 00000000.
>
>
> 4. A second version of the code has a different error when I load
the .exe
> file
>
> Execption EDatabaseError in
> module C***.exe at 013:11EB.
> An error occured while attempting to initialize the Borland Database
Engine
> (error $2108)
>
>
> Where are the options to start the BDE ? And when referring to a
> 'servername: C:\blah\database\*.fdb' location, what does the
'servername:'
> derive its name from ? ie. as in Question 2 above.
>

Servername should be the hostname or IP address of the
Firebird/Interbase server.

BDE (Borland Database Engine) is a depricated connection library that
was designed to simplify connection to various databases by creating a
standard set of components. Of course, it had to dumb down databases
because not all databases supported acid transactions.

>
> 5. Furthermore, when I open some of the .pas files that refer to the
> database, a component of TDatabase, I get the following errors
within the
> Structure window:
> >"Undeclared identifier 'TDatabase' at line 36 (36:13)"
> >"TDatabase does not contain a member named 'Connected' at line...
> >"TDatabase does not " " " " 'Open' ,
'Close',
> 'Params' .... at line ..
>
> I presume the code contains obsolete definitions for the database
objects.
> Should I be using some of the dBGo utilities ?
>
>
> 6. I tired making a simple Form that connects to a pre-existing
Firebird DB,
> (.gdb file).

When you do get it ported, rename the Firebird database to .fdb to
prevent a bug in Windows.

> However, when I try to set the TDatabase.Connected Property
> to true, I get the error from Question 2 (Unknown Database,
IB_SERVER). What
> are the parameter settings supposed to be if you have the database file
> stored locally, user as sysdba and password as masterkey?
>
> Also, I tried to compile the application, however, I get the error
'Director
> is Busy'. How do I avoid this error ?
>
> Is a TSession necessary for connecting to a database ?
>
>
> 7. Is there a good reference for the IBObjects website ? Do users of
> Delphi/C++ recommend using the components ? And how do you learn
about it if
> you don't order the manual ?

There are a list of components at fbtalk.net you can consider. In this
case, I wonder if it would be easier to attempt to extract the data
and pump it into a new structure.

Adam