Re: [firebird-support] Re: using embedded

2017-07-27 Thread keith prosser prosse...@yahoo.com [firebird-support] 
All sorted - apparently you have to use the 32 bit version of embedded with 
dephi 7(ie 32-bit)  applications even on 64 bit windows.  
I just wish that sort of thing was easier to dig out!


On Thu, 27/7/17, Safir Helo safirh...@yahoo.fr [firebird-support] 
 wrote:

 Subject: [firebird-support] Re: using embedded
 To: "firebird-support@yahoogroups.com" 
 Date: Thursday, 27 July, 2017, 10:20
 
 
  
 
 
 
   
 
 
 
   
   
   witch version of Firebird are
 you using ?
 
 
 
 
  
 
 
 
 
 
 
 #yiv9880677705 #yiv9880677705 --
   #yiv9880677705ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}
 
 #yiv9880677705 #yiv9880677705ygrp-mkp hr {
 border:1px solid #d8d8d8;}
 
 #yiv9880677705 #yiv9880677705ygrp-mkp #yiv9880677705hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}
 
 #yiv9880677705 #yiv9880677705ygrp-mkp #yiv9880677705ads {
 margin-bottom:10px;}
 
 #yiv9880677705 #yiv9880677705ygrp-mkp .yiv9880677705ad {
 padding:0 0;}
 
 #yiv9880677705 #yiv9880677705ygrp-mkp .yiv9880677705ad p {
 margin:0;}
 
 #yiv9880677705 #yiv9880677705ygrp-mkp .yiv9880677705ad a {
 color:#ff;text-decoration:none;}
 #yiv9880677705 #yiv9880677705ygrp-sponsor
 #yiv9880677705ygrp-lc {
 font-family:Arial;}
 
 #yiv9880677705 #yiv9880677705ygrp-sponsor
 #yiv9880677705ygrp-lc #yiv9880677705hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}
 
 #yiv9880677705 #yiv9880677705ygrp-sponsor
 #yiv9880677705ygrp-lc .yiv9880677705ad {
 margin-bottom:10px;padding:0 0;}
 
 #yiv9880677705 #yiv9880677705actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}
 
 #yiv9880677705 #yiv9880677705activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
 
 #yiv9880677705 #yiv9880677705activity span {
 font-weight:700;}
 
 #yiv9880677705 #yiv9880677705activity span:first-child {
 text-transform:uppercase;}
 
 #yiv9880677705 #yiv9880677705activity span a {
 color:#5085b6;text-decoration:none;}
 
 #yiv9880677705 #yiv9880677705activity span span {
 color:#ff7900;}
 
 #yiv9880677705 #yiv9880677705activity span
 .yiv9880677705underline {
 text-decoration:underline;}
 
 #yiv9880677705 .yiv9880677705attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}
 
 #yiv9880677705 .yiv9880677705attach div a {
 text-decoration:none;}
 
 #yiv9880677705 .yiv9880677705attach img {
 border:none;padding-right:5px;}
 
 #yiv9880677705 .yiv9880677705attach label {
 display:block;margin-bottom:5px;}
 
 #yiv9880677705 .yiv9880677705attach label a {
 text-decoration:none;}
 
 #yiv9880677705 blockquote {
 margin:0 0 0 4px;}
 
 #yiv9880677705 .yiv9880677705bold {
 font-family:Arial;font-size:13px;font-weight:700;}
 
 #yiv9880677705 .yiv9880677705bold a {
 text-decoration:none;}
 
 #yiv9880677705 dd.yiv9880677705last p a {
 font-family:Verdana;font-weight:700;}
 
 #yiv9880677705 dd.yiv9880677705last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}
 
 #yiv9880677705 dd.yiv9880677705last p
 span.yiv9880677705yshortcuts {
 margin-right:0;}
 
 #yiv9880677705 div.yiv9880677705attach-table div div a {
 text-decoration:none;}
 
 #yiv9880677705 div.yiv9880677705attach-table {
 width:400px;}
 
 #yiv9880677705 div.yiv9880677705file-title a, #yiv9880677705
 div.yiv9880677705file-title a:active, #yiv9880677705
 div.yiv9880677705file-title a:hover, #yiv9880677705
 div.yiv9880677705file-title a:visited {
 text-decoration:none;}
 
 #yiv9880677705 div.yiv9880677705photo-title a,
 #yiv9880677705 div.yiv9880677705photo-title a:active,
 #yiv9880677705 div.yiv9880677705photo-title a:hover,
 #yiv9880677705 div.yiv9880677705photo-title a:visited {
 text-decoration:none;}
 
 #yiv9880677705 div#yiv9880677705ygrp-mlmsg
 #yiv9880677705ygrp-msg p a span.yiv9880677705yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}
 
 #yiv9880677705 .yiv9880677705green {
 color:#628c2a;}
 
 #yiv9880677705 .yiv9880677705MsoNormal {
 margin:0 0 0 0;}
 
 #yiv9880677705 o {
 font-size:0;}
 
 #yiv9880677705 #yiv9880677705photos div {
 float:left;width:72px;}
 
 #yiv9880677705 #yiv9880677705photos div div {
 border:1px solid
 #66;min-height:62px;overflow:hidden;width:62px;}
 
 #yiv9880677705 #yiv9880677705photos div label {
 
color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
 
 #yiv9880677705 #yiv9880677705reco-category {
 font-size:77%;}
 
 #yiv9880677705 #yiv9880677705reco-desc {
 font-size:77%;}
 
 #yiv9880677705 .yiv9880677705replbq {
 margin:4px;}
 
 #yiv9880677705 #yiv9880677705ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}
 
 #yiv9880677705 #yiv9880677705ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}
 
 #yiv9880677705 #yiv9880677705ygrp-mlmsg table {

[firebird-support] Re: using embedded

2017-07-27 Thread Safir Helo safirh...@yahoo.fr [firebird-support] 
witch version of Firebird are you using ?

Re: [firebird-support] Compatibility questions: Current release versus 1.5.3.4870

2017-07-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
On 2017-07-27 00:58, 'Leyne, Sean' s...@broadviewsoftware.com 
[firebird-support] wrote:
> My question (and I'm sorry if I'm asking this before doing any
> research on my own) is simply, how compatible is the 2.5 version with
> databases created with 1.5.3?

Firebird 2.5 can read databases from Interbase 6.0, and from Firebird 
1.0 and higher without problems, however that doesn't mean that 
applications using that database can't break. For example new keywords 
would mean that columns or tables with the same name now need to be 
quoted in the query string. That is assuming you even use dialect 3, 
otherwise, if you are still using dialect 1, the problem could be even 
bigger. There were - iirc - also some changes with joins and alias use 
that could break queries.

Mark

Re: [firebird-support] Compatibility questions: Current release versus 1.5.3.4870

2017-07-27 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
On 2017-07-26 17:52, scott...@comcast.net [firebird-support] wrote:
> Hello!
> 
> I know it's been a while since I've posted on this Group, but current
> circumstances have brought me back.
> 
> Today, I discovered that Microsoft forcibly removed fbserver & fbguard
> for version 1.5.3.4870. This version is included with SAM Broadcaster
> v3, which is critical to my work as an "On-Net Personality" on a very
> popular music stream. There was no warning for it's removal at the
> Windows 10 Creator's Update "updates" that happened recently. All of
> the files for Firebird were removed. The application's DB is safe.
> When trying to re-install Firebird-1.5.3.4870-0-Win32.exe, Windows
> throws the "This App can't run on your PC" message with "Firebird
> doesn't work on this version of Windows. An updated app may be
> available" message and shows buttons with "Learn more" and "Close"
> I've been running the 1.5.3.4870 build under Windows 10 with *zero*
> problems up until the last update.

Technically, Firebird 1.5 is not compatible with Windows 10, iirc it 
hasn't even been compatible with Windows Vista. However I do know 
Firebird 1.5 can run on Windows 10, but for example the local protocol 
doesn't work. I suggest you try 1.5.6 first (I don't really understand 
why you are still three point-release behind the latest 1.5; 1.5.3 was 
released in 2005, 1.5.6 in 2009). However I expect that the 1.5.6 
installer won't work either. The alternative is to try to use the zipkit 
(see https://www.firebirdsql.org/en/firebird-1-5/).

That is: manually install Firebird from a zip archive, and register 
services and client DLL manually as necessary using instsvc and 
instclient.

And you could always try to use a VM with an earlier windows version to 
run Firebird.

> 
> My question (and I'm sorry if I'm asking this before doing any
> research on my own) is simply, how compatible is the 2.5 version with
> databases created with 1.5.3?

Please consult the release notes of Firebird 2.0, 2.1 and 2.5 for 
compatible changes. However, I suggest that if you are in panic

> I'm nearly in panic-mode here, and exploring all options to get this
> resolved.

I suggest you don't jump and upgrade to Firebird 2.5 in panic, but try 
the zipkit first, and then when things have settled down, you should 
investigate upgrading to Firebird 3 (or 2.5), and carefully test your 
application. However don't do this in a rush. There were a number of 
breaking changes (some of them subtle!) between 1.5 and 2.0.

Good luck,

Mark