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


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

2017-07-26 Thread Alexandre Benson Smith ibl...@thorsoftware.com.br [firebird-support]

Hi !

It's dificult to tell... From version to version there is minor problens 
that can occur, like new reserved wirds and so on.


But in general, you will be safe doing the upgrade.

It's recommend to perform a back-up/restore cycle to upgrade de database 
ODS. But FB 2.5 can read databases created by 1.5 version.


You have a problem, in the actual state, it's not working, what can you 
lost if you try to upgrade and discover that it will not work ?


Make a copy of the database and give it a try, it will not hurt.

good luck !



Em 26/7/2017 12:52, scott...@comcast.net [firebird-support] escreveu:



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.

*/
/*
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?


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


Thanks!

--Scott Kindorf
General Manager,
The WebMaster Internet Radio Network
On-Net Personality
"The ScottK Radio Show" on WebMaster Internet Radio Network.




--
Alexandre Benson Smith
Santo Andre - Sao Paulo - Brazil



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

2017-07-26 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]

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?

 There is no easy answer to your question – it depends…

 Have you considered rolling back the Win10 update?

 The update should have create a pre-update System Restore point…




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

2017-07-26 Thread scott...@comcast.net [firebird-support]
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.
 

 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?
 

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

 Thanks!
 

 --Scott Kindorf
 General Manager, 
 The WebMaster Internet Radio Network
 On-Net Personality
 "The ScottK Radio Show" on WebMaster Internet Radio Network.