What is the cost of maintaining dialect 1 connectivity? Isn't it more work
to remove it than to leave it go for some time?
I would like to think that
1. The client lib is finally changed over
2. Most (if not all) third party connection components have had a chance to
move over to the new 'gds' lib
3. FB is finally able to co-habit without problem on a host with Interbase
already installed, and
4. Some time after 1-3 has taken place a reasonable transition period is
provided
before dialect 1 is yanked.

Alan


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Wednesday, 9 October 2002 11:20
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Firebird and the BDE/SQL Links


At 08:10 PM 08-10-02 -0400, you wrote:

>We currently have two IB 6.0 dialect 1 databases hosted on the same

server

>that we're accessing using Paradox for Windows via the BDE and SQL Links.

I'm

>getting ready to start a new project and I'd like to develop it using
>Firebird as well as converting the two existing databases to FB. All

three

>would be running on
>the same server. We are committed to leaving the current applications and
>developing the new app in Paradox - yes, for valid reasons! The server

will be

>running Windows 2000.
>
>Anyway, I have several questions about FB and the BDE that I had hoped to
>answer by experimenting, but time's running out so I'm hoping I can get

the

>answers here!
>
>o There will be a transition period to move the old apps to Firebird,
>aggravated by the fact that several locations are accessing the data.

Will

>the FB client
>connect to IB databases?
>
>o Can the IB6 client connect to FB?

Possibly, but it's not recommended, due to bugfixes and API additions done
to the Fb client over the past 2.25 years.

>o How does the BDE/SQL Links work with FB1? FB1.5? Is it too early to

tell

>about FB2?

Not. The latest (and last) BDE driver is 5.2, which ships with Delphi
6. It has problems with both InterBase and Firebird. BDE is dead for
RDBMS support. Borland has strongly indicated that it's there for ISAM
databases only.

>o If the filename and/or registry keys for FB are different than IB's,
>will the BDE/SQL Links be able to find 'em?

Interesting question...can't answer as I've never used the BDE with
Firebird.

>o Has any decision been made on how long dialect 1 will be supported in

FB?

Not much longer. There's currently debate about WHEN to drop it but no
question that it will be dropped.

Quite seriously, I don't fancy your plan to use PfW for Fb or
InterBase. At best your clients will be operating on private ANSWER.DB
files, with an absolute lack of concurrency control and detachment from
the
integrity constraints of the DBMS. You will be considerably worse-off
than
if you stuck with Paradox. "Horses for courses".

heLen


Yahoo! Groups Sponsor
ADVERTISEMENT





To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]