<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:windowtext;}
h4
{mso-style-priority:9;
mso-style-link:"Heading 4 Char";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:10.0pt;
font-family:"Times New Roman","serif";
color:black;
font-weight:bold;
font-style:italic;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:10.0pt;
font-family:"Times New Roman","serif";
color:black;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.Heading4Char
{mso-style-name:"Heading 4 Char";
mso-style-priority:9;
mso-style-link:"Heading 4";
color:black;
font-weight:bold;
font-style:italic;}
span.quote
{mso-style-name:quote;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-NZ link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi John<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><h4><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>At <a name=d0e41491></a><a href="http://www.firebirdsql.org/manual/ufb-cs-appdev.html">http://www.firebirdsql.org/manual/ufb-cs-appdev.html</a> I read <o:p></o:p></span></h4><h4><span lang=EN style='font-family:"Verdana","sans-serif"'>The Borland Database Engine (BDE) <o:p></o:p></span></h4><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:black'>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. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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? <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>There is a download link here for BDE 5.2. <a href="http://www.stockblocks.com/support/bde/">http://www.stockblocks.com/support/bde/</a> (I have not tried the link).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Best regards,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Russell<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> delphi-bounces@listserver.123.net.nz [mailto:delphi-bounces@listserver.123.net.nz] <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<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:navy'> <o:p></o:p></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<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:navy'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:navy'>Have installed Firebird server and the database.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:navy'> <o:p></o:p></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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:navy'> <o:p></o:p></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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:navy'> <o:p></o:p></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.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:navy'> <o:p></o:p></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?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:navy'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-family:"Verdana","sans-serif";color:navy'>John Bird<o:p></o:p></span></p></div></div></div></div></body></html>