At 06:35 PM 07-01-02 +0100, you wrote:

>today I installed Firebird (v. WI-T1.0.0.679).
>
>I could connect using WISQL.
>
>I could connect using DatabaseDesktop.
>
>I could connect using a TTable.
>
>I could connect using IBO.
>
>However, trying to connect using a TDatabase, always ends with the
>error message "invalid parameter".
>
>I tried - I guess - all possible settings and parameters.
>
>Is this a known issue ?

Duilio,

Don't use the TTable connection for a client/server database - that is for connecting to spreadsheets and other similar ODBC sources...

If you are using TDatabase, you need to set up a BDE alias (e.g. MyDB) on the client machine using the native InterBase (INTRBASE) driver.

For a TCP/IP connection you need the following in the Servername:
e.g.
MYSERVER:c:\data\test\test.gdb

or, for a local connection,

c:\data\test\test.gdb

Once you have done this and saved it, open your Delphi project and set the following properties:

For Aliasname, drop down the list and select the alias you just created.

For Databasename, you can do the same, or make up a simple name.

For development purposes, you can set LoginPrompt false and set some Params (this is insecure in production though)

For Params, set as follows (substitute your own password):

USER=SYSDBA
PASSWORD=masterkey (remember this is case-sensitive)

(if you already have a BDE alias set up, this is very likely where your error is coming from)

Then toggle Connected to true and it should connect (as long as you have the server running, of course!)

After that, for your data access objects, select the alias as the Databasename property.

Just a warning, though - the BDE version in Delphi 3 doesn't have an InterBase 6 driver. You may be OK with a dialect 1 database but you would certainly have problems with dialect 3.

cheers,
Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________