Subject | Re: [ib-support] Delphi3 and Firebird: can they wrok together ? |
---|---|
Author | Duilio Foschi |
Post date | 2002-01-08T08:24:44Z |
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:
certainly have problems with dialect 3.
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:connecting to spreadsheets and other similar ODBC sources...
>>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
>the client machine using the native InterBase (INTRBASE) driver.
>If you are using TDatabase, you need to set up a BDE alias (e.g. MyDB) on
>following properties:
>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
>Params (this is insecure in production though)
>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
>error is coming from)
>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
>the server running, of course!)
>Then toggle Connected to true and it should connect (as long as you have
>Databasename property.
>After that, for your data access objects, select the alias as the
>InterBase 6 driver. You may be OK with a dialect 1 database but you would
>Just a warning, though - the BDE version in Delphi 3 doesn't have an
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/
>
>
>
>