Subject Re: [ib-support] Delphi3 and Firebird: can they wrok together ?
Author Duilio Foschi
Helen,

I read your instructions and had an impression of old stuff.

Then I followed your instructions step after step and ... the TDatabase
connected !

No idea of what I did wrong the other day.

Thanks a lot. You were very helpful

Duilio



At 11.01 08/01/02 +1100, you wrote:
>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
>_______________________________________________________
>
>
>
>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/
>
>
>
>