Re: [firebird-support] COMMENT ON charset
Thanks ! It worked well with the switch -ch "UTF-8" El 20/12/18 a las 16:03, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] escribió: > 20.12.2018 19:10, Aldo Caruso aldo.car...@argencasas.com [firebird-support] > wrote: >> The sql script is coded in UTF-8 > You must inform server about it using SET NAMES before CONNECT or -ch > switch. >
Re: [firebird-support] Firebird 2.5 ppa repository for Ubuntu 18.04
20.12.2018 18:40, my...@techsol.org [firebird-support] wrote: > Thank you. Do you happen to know the PPA address of those repositories for > Ubuntu 16.04? > I haven't upgraded my development workstation to 18.04 yet (will do that in > the new year). https://packages.ubuntu.com/search?keywords=firebird&searchon=names&suite=xenial§ion=all -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] COMMENT ON charset
20.12.2018 19:10, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > The sql script is coded in UTF-8 You must inform server about it using SET NAMES before CONNECT or -ch switch. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] COMMENT ON charset
Hello, How is defined the chartset used in a COMMENT ON statement ? I'm getting into trouble when I execute a sql script containing COMMENT ON statements, using isql-fb -input
Re: [firebird-support] Firebird 2.5 ppa repository for Ubuntu 18.04
Thank you. Do you happen to know the PPA address of those repositories for Ubuntu 16.04? I haven't upgraded my development workstation to 18.04 yet (will do that in the new year). Thanks Myles
Re: [firebird-support] Using FB 3.04 with Delphi 10.2
Thanks Mark, I am. If I didn't have this "issue" on my own setup it would have been a problem at customer sites, but now all resolved. RTFM - I have now! Thanks again, and to John. Alan J Davies Aldis On 20/12/2018 16:25, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 20-12-2018 14:49, Alan J Davies alan.dav...@aldis-systems.co.uk > [firebird-support] wrote: > > Thanks John - spot on! I had the connection set correctly in the > > program's connection string but in Ibexpert (my database tool of choice) > > I had set it as Local to test FB3 when I set it up and had not changed > > it to remote tcp/ip with server name etc. It works perfectly now and I > > can happily start upgrading other user systems. > > This could indicate that you were previously using Classic or > SuperClassic (which opens a database with a shared filelock), and are > now using SuperServer (which opens a database with an exclusive filelock). > > Mark > -- > Mark Rotteveel > >
Re: [firebird-support] Using FB 3.04 with Delphi 10.2
On 20-12-2018 14:49, Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support] wrote: > Thanks John - spot on! I had the connection set correctly in the > program's connection string but in Ibexpert (my database tool of choice) > I had set it as Local to test FB3 when I set it up and had not changed > it to remote tcp/ip with server name etc. It works perfectly now and I > can happily start upgrading other user systems. This could indicate that you were previously using Classic or SuperClassic (which opens a database with a shared filelock), and are now using SuperServer (which opens a database with an exclusive filelock). Mark -- Mark Rotteveel
Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4
On 19-12-2018 17:33, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Although I haven't read it myself, consider buying "Migration Guide to > Firebird 3" by Carlos Cantu, see > https://www.firebirdnews.org/migration-guide-to-firebird-3/ And now I have read it, I can say that I stand by my earlier endorsement: consider by it. Mark -- Mark Rotteveel
Re: [firebird-support] Using FB 3.04 with Delphi 10.2
Thanks John - spot on! I had the connection set correctly in the program's connection string but in Ibexpert (my database tool of choice) I had set it as Local to test FB3 when I set it up and had not changed it to remote tcp/ip with server name etc. It works perfectly now and I can happily start upgrading other user systems. Regards Alan Alan J Davies Aldis On 20/12/2018 11:17, John vdW j...@jvdw.nl [firebird-support] wrote: > Sounds to me you are using local access to the database, either in the > IDE or when running the program (or both). > Does the connection params contain a hostname or ipnr? If not, it's > probably a local connection. In that case only one process can connect > to the db. The IDE (connection component) may be stay connected, so when > running the program you get this error. > > John > > Op 20-12-2018 om 12:00 schreef Alan J Davies > alan.dav...@aldis-systems.co.uk [firebird-support]: > > Hi I use FB3.04 and Delphi for writing the front-end programs. I had no > > problems with FB 2.5 for years, but now I've upgraded I have problems > > every time I run a compile and run cycle. > > I get the error - "Error while trying to open the file - the process > > cannot access the file because it is being used by another process." > > > > The file in question is the database so I have to close the database > > every time I make a change which means I cannot check what's going on in > > the event of an error. Then everything works perfectly. > > This did not happen with FB 2.5 > > Is there a setting or something similar in FB to allow this? > > The OS is Windows 10, 16GB, SSD drives > > > > Thanks > > Alan > >
Re: [firebird-support] Using FB 3.04 with Delphi 10.2
Sounds to me you are using local access to the database, either in the IDE or when running the program (or both). Does the connection params contain a hostname or ipnr? If not, it's probably a local connection. In that case only one process can connect to the db. The IDE (connection component) may be stay connected, so when running the program you get this error. John Op 20-12-2018 om 12:00 schreef Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]: > Hi I use FB3.04 and Delphi for writing the front-end programs. I had no > problems with FB 2.5 for years, but now I've upgraded I have problems > every time I run a compile and run cycle. > I get the error - "Error while trying to open the file - the process > cannot access the file because it is being used by another process." > > The file in question is the database so I have to close the database > every time I make a change which means I cannot check what's going on in > the event of an error. Then everything works perfectly. > This did not happen with FB 2.5 > Is there a setting or something similar in FB to allow this? > The OS is Windows 10, 16GB, SSD drives > > Thanks > Alan
Re: [firebird-support] Using FB 3.04 with Delphi 10.2
20.12.2018 12:00, Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support] wrote: > Is there a setting or something similar in FB to allow this? Yes. Read "Compatibility Issues" chapter in Release Notes (or better read whole of them). -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Using FB 3.04 with Delphi 10.2
Hi I use FB3.04 and Delphi for writing the front-end programs. I had no problems with FB 2.5 for years, but now I've upgraded I have problems every time I run a compile and run cycle. I get the error - "Error while trying to open the file - the process cannot access the file because it is being used by another process." The file in question is the database so I have to close the database every time I make a change which means I cannot check what's going on in the event of an error. Then everything works perfectly. This did not happen with FB 2.5 Is there a setting or something similar in FB to allow this? The OS is Windows 10, 16GB, SSD drives Thanks Alan -- Alan J Davies Aldis
Re: [firebird-support] Firebird 2.5 ppa repository for Ubuntu 18.04
20.12.2018 3:03, my...@techsol.org [firebird-support] wrote: > Is there a more up to date repository for Firebird 2.5 for Ubuntu 18.04 LTS > that any one > can point me to? Firebird 2.5 is in official Ubuntu 18.04 repositories. Just use 'apt-get install firebird-2.5'. It may be a bit outdated though... -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/