<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Verdana'; COLOR: #000080; FONT-SIZE: 12pt">
<DIV>I followed the link and comments on the article, and one of them</DIV>
<DIV> </DIV>
<DIV><A
title=http://threads.embarcadero.com/threads/threads.exe/view?commentid=32620
href="http://threads.embarcadero.com/threads/threads.exe/view?commentid=32620">http://threads.embarcadero.com/threads/threads.exe/view?commentid=32620</A></DIV>
<DIV> </DIV>
<DIV>from a Borland ex employee implies that the BDE is a more robust
implementation than what followed it (as Borlands own products depended on it) –
its main disadvantage being tied to DBase and Paradox architecture.</DIV>
<DIV> </DIV>
<DIV>Any other opinions? How many out there use the BDE, or what works
best for them with Firebird (I have heard much good about IBObjects)</DIV>
<DIV> </DIV>
<DIV style="FONT-FAMILY: 'Verdana'; COLOR: #000080; FONT-SIZE: 12pt">John
Bird<BR>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none"></DIV>
<DIV style="FONT: 10pt tahoma">
<DIV style="BACKGROUND: #f5f5f5">
<DIV style="font-color: black"><B>From:</B> <A title=alister@salespartner.co.nz
href="mailto:alister@salespartner.co.nz">Alister Christie</A> </DIV>
<DIV><B>Sent:</B> Thursday, June 14, 2012 1:08 PM</DIV>
<DIV><B>To:</B> <A title=delphi@listserver.123.net.nz
href="mailto:delphi@listserver.123.net.nz">NZ Borland Developers Group - Delphi
List</A> </DIV>
<DIV><B>Subject:</B> Re: [DUG] Firebird V2 BDE Windows 7</DIV></DIV></DIV>
<DIV> </DIV></DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">I
believe that the SQL Links in the BDE have been deprecated
<DIV><A
href="http://edn.embarcadero.com/article/28688">http://edn.embarcadero.com/article/28688</A> <BR><BR>
<DIV class=gmail_quote>On Thu, Jun 14, 2012 at 10:41 AM, John Bird <SPAN
dir=ltr><<A href="mailto:johnkbird@paradise.net.nz"
target=_blank>johnkbird@paradise.net.nz</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV dir=ltr lang=EN-NZ link="blue" vlink="purple">
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Verdana'; COLOR: #000080; FONT-SIZE: 12pt">
<DIV>I got a solution for this problem after much experimentation:</DIV>
<DIV> </DIV>
<DIV>I checked carefully the BDE setup as from Delphi 5, and the BDE as
installed by Delphi 2007/XE2. The later install was missing the
Firebird/interbase driver, so I downloaded the ODBC driver (its readily
available) and installed it. However it does not work, so I compared
with the older BDE which has the same version number but is not exactly the
same - it has a native Interbase driver built in (INTRBASE) so I installed the
older BDE and hey presto that was the final missing link.</DIV>
<DIV> </DIV>
<DIV>Under Windows 7 the Setup has to run as Administrator as well.</DIV>
<DIV> </DIV>
<DIV>Maybe under XE2 Professional the native Interbase/Firebird driver is
omitted from the BDE? That may be the case because I see its
present in the XE2 Enterprise BDE. Seems a bit scummy and petty to
take it out of a component that hasn’t otherwise been modified for 12
years!</DIV>
<DIV> </DIV>
<DIV>The reason for sticking with BDE is that yes its a bother to set up on
the client PCs but thats a once off pain and OK if you have a good
install. The program uses the TQuery component very widely, which
has the nice feature of being able to do updates as well with specified fields
– the effort to change to other update mechanisms right though the code is
more than the bother of using the BDE.</DIV>
<DIV> </DIV>
<DIV>Personally I rather like the BDE type of operation, simple and
reliable and compares well to ADOQuery and IBQuery. What do others
think?</DIV>
<DIV> </DIV>
<DIV style="FONT-FAMILY: 'Verdana'; COLOR: #000080; FONT-SIZE: 12pt">John
Bird<BR>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none"></DIV> </DIV>
<DIV
style="FONT-STYLE: normal; DISPLAY: inline; FONT-FAMILY: 'Calibri'; COLOR: #000000; FONT-SIZE: small; FONT-WEIGHT: normal; TEXT-DECORATION: none">
<DIV>
<DIV class=h5>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Hi
John<U></U><U></U></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><U></U><U></U></SPAN> </P>
<H4><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">At
<A name=137e80464c6dd736_d0e41491></A><A
href="http://www.firebirdsql.org/manual/ufb-cs-appdev.html"
target=_blank>http://www.firebirdsql.org/manual/ufb-cs-appdev.html</A> I read
<U></U><U></U></SPAN></H4>
<H4><SPAN style="FONT-FAMILY: 'Verdana','sans-serif'" lang=EN>The Borland
Database Engine (BDE) <U></U><U></U></SPAN></H4>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: black; FONT-SIZE: 10pt"
lang=EN>Borland markets “enterprise versions” of a number of integrated
development tools – Delphi, Kylix, C++Builder, JBuilder and some older
products – which can use the proprietary Borland Database Engine and native
SQL Links InterBase drivers as a “black box” middleware layer to make
InterBase and, latterly, Firebird databases behave like desktop databases. BDE
version 5.2 and its associated InterBase driver, which first shipped with
Delphi 6E, supports both Firebird and InterBase version 6, although it has
known bugs affecting the Dialect 3 date and time data types.
<U></U><U></U></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">I
used the BDE extensively once and would run a long way to avoid it now. I
converted one largish BDE app to FB2.5 +IBObjects. No significant problems. So
much for a grizzle. You may have compelling reasons to hang with the
BDE. Perhaps a replacement from 5.01 to 5.2 would help?
<U></U><U></U></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><U></U><U></U></SPAN> </P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">There
is a download link here for BDE 5.2. <A
href="http://www.stockblocks.com/support/bde/"
target=_blank>http://www.stockblocks.com/support/bde/</A> (I have not tried
the link).<U></U><U></U></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><U></U><U></U></SPAN> </P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Best
regards,<U></U><U></U></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt">Russell<U></U><U></U></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d; FONT-SIZE: 11pt"><U></U><U></U></SPAN> </P>
<DIV>
<DIV
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"
lang=EN-US>From:</SPAN></B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt" lang=EN-US> <A
href="mailto:delphi-bounces@listserver.123.net.nz"
target=_blank>delphi-bounces@listserver.123.net.nz</A> [mailto:<A
href="mailto:delphi-bounces@listserver.123.net.nz"
target=_blank>delphi-bounces@listserver.123.net.nz</A>] <B>On Behalf Of
</B>John Bird<BR><B>Sent:</B> Wednesday, 13 June 2012 9:59 p.m.<BR><B>To:</B>
NZ Borland Developers Group - Delphi List<BR><B>Subject:</B> [DUG] Firebird V2
BDE Windows 7<U></U><U></U></SPAN></P></DIV></DIV>
<P class=MsoNormal><U></U><U></U> </P>
<DIV>
<DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy">I am getting a legacy
program that uses both BDE and TIB connections to a Firebird V2 database
working on Windows 7.<U></U><U></U></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy"><U></U><U></U></SPAN> </P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy">Have installed BDE
(the old version – V5.01) OK – the trick is to install as
Administrator<U></U><U></U></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy"><U></U><U></U></SPAN> </P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy">Have installed
Firebird server and the database.<U></U><U></U></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy"><U></U><U></U></SPAN> </P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy">Can connect to it
using EMS SQL Manager and Flamerobin just fine and browse the tables and run
SQL etc. – ie the Database file and server all look
fine.<U></U><U></U></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy"><U></U><U></U></SPAN> </P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy">the programs TIBQuery
connection also seems to be working OK.<U></U><U></U></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy"><U></U><U></U></SPAN> </P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy">However I cannot
connect to it using BDE – it looks like the problem is the driver.
I installed the Firebird/Interbase ODBC driver, but it may be that the
original XP PCs using an Intersolv native INTRBASE driver, for which I
don’t have an install, or an install of the BDE that once included an INTRBASE
driver that I don’t have in my fresh BDE
install.<U></U><U></U></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy"><U></U><U></U></SPAN> </P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy">Anyone have
suggestions how to get the BDE connection
working?<U></U><U></U></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy"><U></U><U></U></SPAN> </P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: navy">John
Bird<U></U><U></U></SPAN></P></DIV></DIV></DIV></DIV></DIV></DIV>
<HR>
_______________________________________________<BR>NZ Borland Developers Group
- Delphi mailing list<BR>Post: <A href="mailto:delphi@listserver.123.net.nz"
target=_blank>delphi@listserver.123.net.nz</A><BR>Admin: <A
href="http://delphi.org.nz/mailman/listinfo/delphi"
target=_blank>http://delphi.org.nz/mailman/listinfo/delphi</A><BR>Unsubscribe:
send an email to <A href="mailto:delphi-request@listserver.123.net.nz"
target=_blank>delphi-request@listserver.123.net.nz</A> with Subject:
unsubscribe
</DIV></DIV></DIV></DIV><BR>_______________________________________________<BR>NZ
Borland Developers Group - Delphi mailing list<BR>Post: <A
href="mailto:delphi@listserver.123.net.nz">delphi@listserver.123.net.nz</A><BR>Admin:
<A href="http://delphi.org.nz/mailman/listinfo/delphi"
target=_blank>http://delphi.org.nz/mailman/listinfo/delphi</A><BR>Unsubscribe:
send an email to <A
href="mailto:delphi-request@listserver.123.net.nz">delphi-request@listserver.123.net.nz</A>
with Subject: unsubscribe<BR></BLOCKQUOTE></DIV><BR><BR clear=all>
<DIV> </DIV>-- <BR><PRE cols="72">Alister Christie
Computers for People
Ph: 04 471 1849 Fax: 04 471 1266
<A href="http://www.salespartner.co.nz" target=_blank>http://www.salespartner.co.nz</A>
Follow us on Twitter <A href="http://twitter.com/salespartner" target=_blank>http://twitter.com/salespartner</A>
PO Box 13085
Johnsonville
Wellington</PRE><BR></DIV>
<P>
<HR>
_______________________________________________<BR>NZ Borland Developers Group -
Delphi mailing list<BR>Post: delphi@listserver.123.net.nz<BR>Admin:
http://delphi.org.nz/mailman/listinfo/delphi<BR>Unsubscribe: send an email to
delphi-request@listserver.123.net.nz with Subject:
unsubscribe</DIV></DIV></DIV></BODY></HTML>