RE: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined
<> Yes, by default we build and install as a Framework on MacOS, which means as part of the build process we finesse the locations of all the relevant libraries and executables etc using the install_name_tool. If you look at the source code specifically posix/postfix.darwin, and you will need to do the same for all the libs/executables you wish to use... There was a script to do this in Firebird 2.x See posix/builds/install/arch-specific/darwin/embed.darwin Paul
Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined
I've managed to solve it by patching the libEngine12.dylib file in plugins directory, as well as setting the DYLD_LIBRARY_PATH to the application directory. install_name_tool -change /Library/Frameworks/Firebird.framework/Versions/A/Firebird @executable_path/libfbclient.dylib plugins/libEngine12.dylib export DYLD_LIBRARY_PATH=$(pwd) Cheers! On Thu, Apr 25, 2019 at 4:42 PM Anil wrote: > BTW, what are the equivalents of these libraries on macOS? > I didn't manage to solve the issue on macOS by including these: > >- libicudata.dylib >- libib_util.dylib >- libicuuc.dylib >- libicui18n.dylib > > > > On Fri, Apr 12, 2019 at 1:12 PM Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: > >> >> >> On 2019-04-11 20:03, Dimitry Sibiryakov s...@ibphoenix.com >> [firebird-support] wrote: >> > 11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: >> >> It seems that the DB creation on Windows is resulting in an invalid DB >> >> file. >> > >> > Yes. Because you didn't put all necessary files into proper >> > directory structure, >> > Firebird engine failed to load fbintl module. Database file was created >> > but not >> > initialized properly. Because of this you was unable to use it from >> > isql. >> >> As far as I'm aware, UTF8 doesn't need fbintl, however it does need ICU. >> >> Mark >> >> >
Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined
BTW, what are the equivalents of these libraries on macOS? I didn't manage to solve the issue on macOS by including these: - libicudata.dylib - libib_util.dylib - libicuuc.dylib - libicui18n.dylib On Fri, Apr 12, 2019 at 1:12 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2019-04-11 20:03, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] wrote: > > 11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: > >> It seems that the DB creation on Windows is resulting in an invalid DB > >> file. > > > > Yes. Because you didn't put all necessary files into proper > > directory structure, > > Firebird engine failed to load fbintl module. Database file was created > > but not > > initialized properly. Because of this you was unable to use it from > > isql. > > As far as I'm aware, UTF8 doesn't need fbintl, however it does need ICU. > > Mark > >
Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined
On 2019-04-11 20:03, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: >> It seems that the DB creation on Windows is resulting in an invalid DB >> file. > >Yes. Because you didn't put all necessary files into proper > directory structure, > Firebird engine failed to load fbintl module. Database file was created > but not > initialized properly. Because of this you was unable to use it from > isql. As far as I'm aware, UTF8 doesn't need fbintl, however it does need ICU. Mark
Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined
I have extracted the whole Firebird-3.0.4.33054-0_x64 package into application directory, but unfortunately it didn't help. Is the default location of fbintl (intl sub-directory) where it's expected to be referenced from? On Thu, Apr 11, 2019 at 8:12 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: > > It seems that the DB creation on Windows is resulting in an invalid DB > file. > >Yes. Because you didn't put all necessary files into proper directory > structure, > Firebird engine failed to load fbintl module. Database file was created > but not > initialized properly. Because of this you was unable to use it from isql. > > > -- >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 > > > >
Re: [firebird-support] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined
11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote: > It seems that the DB creation on Windows is resulting in an invalid DB file. Yes. Because you didn't put all necessary files into proper directory structure, Firebird engine failed to load fbintl module. Database file was created but not initialized properly. Because of this you was unable to use it from isql. -- 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] Problem with Firebird embedded on Windows: CHARACTER SET UTF8 is not defined
I'm using Firebird 3.0 from .NET Core 2.1 application in embedded mode. Database is created using FbConnection.CreateDatabase. However, when trying to execute first query I get following exception. The application works fine on Windows 10 development machine, but I wanted to test the deployment story with Windows Server 2008 R2 and Windows Server 2012 - same error on both: FirebirdSql.Data.FirebirdClient.FbException: bad parameters on attach or create database CHARACTER SET UTF8 is not defined >>> FirebirdSql.Data.Common.IscException: bad parameters on attach or create >>> database CHARACTER SET UTF8 is not defined at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString) at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) at FirebirdSql.Data.FirebirdClient.FbConnection.Open() When I try to access the DB with isql i get following issue: C:\Users\xxx\Temp>isql STATE.FDB Statement failed, SQLSTATE = XX000 internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2324) Statement failed, SQLSTATE = XX000 internal Firebird consistency check (can't continue after bugcheck) Statement failed, SQLSTATE = XX000 internal Firebird consistency check (can't continue after bugcheck) Database: STATE.FDB If I take the DB created on e.g. Mac (with same application) it is being read properly by the application on Windows Server. It seems that the DB creation on Windows is resulting in an invalid DB file.