internals:windows:libs:firebird

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
internals:windows:libs:firebird [2013/04/08 14:08] – [Common requirements] no need for borland files mariuzinternals:windows:libs:firebird [2018/01/23 10:17] (current) – upgrade firebird version to 3.0.x mariuz
Line 1: Line 1:
 ====== Firebird client for Windows, How to compile ====== ====== Firebird client for Windows, How to compile ======
 Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms.
-For more information, please see: [[http://www.firebirdsql.org/|Firebird homepage]] and [[http://www.firebirdsql.org/index.php?id=about-firebird&nosb=1|the about Firebird page]].+For more information, please see: [[http://www.firebirdsql.org/|Firebird homepage]] and [[http://www.firebirdsql.org/en/about-firebird/|the about Firebird page]].
  
  
Line 7: Line 7:
  
 Client library need to be built against the Firebird's engine version running in the destination environment. Client library need to be built against the Firebird's engine version running in the destination environment.
-Actually, first quarter of 2010, the last official release is Firebird 2.1.32-bit and 64-bit for windows, but for many reasons are downloadable and installable also  1.5.* and 2.0.* versions for windows 32-bit only.+The best official stable release is Firebird 3.0.32-bit and 64-bit for Windows.
 Beware that your web application server may be running a different OS from database server. That means that you can have a web server trying to connect a firebird database server running on Linux or other Unixes. If this is the case you must deploy anyway the correct firebird's client library and install in system directory. Beware that your web application server may be running a different OS from database server. That means that you can have a web server trying to connect a firebird database server running on Linux or other Unixes. If this is the case you must deploy anyway the correct firebird's client library and install in system directory.
  
Line 14: Line 14:
 In the complete file list there are a lot of file, for many different scopes. In the complete file list there are a lot of file, for many different scopes.
 **Don't select** this types of files: **Don't select** this types of files:
-  * with extenxsion .zip+  * with extension .zip
   * containing the string "pdb" in the name   * containing the string "pdb" in the name
   * containing the string "embed" in the name   * containing the string "embed" in the name
Line 34: Line 34:
 If the database server is installed in the same machine of development, needed libraries and include files are allready installed in proper directories. If the database server is installed in the same machine of development, needed libraries and include files are allready installed in proper directories.
  
-If the database server is installed in another machine, the you need to install development files and firebird's client libraries from sourceforge repository.+If the database server is installed in another machine, then you need to install development files and firebird's client libraries from sourceforge repository.
  
 ==== Firebird engine not yet installed, or development only environment ==== ==== Firebird engine not yet installed, or development only environment ====
  
-Packages are downloadble from [[http://sourceforge.net/project/showfiles.php?group_id=9028|sourceforge's repository]]. Select+Packages are downloadable from [[http://sourceforge.net/projects/firebird/files|sourceforge's repository]]. Select
  
-* firebird-win32 for 32-bit windows ( [[http://sourceforge.net/project/showfiles.php?group_id=9028&package_id=29791|here direct link]] )+* firebird-win32 for 32-bit windows ( [[http://sourceforge.net/projects/firebird/files/firebird-win32/|here direct link]] )
  
-* firebird-win64 for 64-bit windows ( [[http://sourceforge.net/project/showfiles.php?group_id=9028&package_id=226496|here direct link]] )+* firebird-win64 for 64-bit windows ( [[http://sourceforge.net/projects/firebird/files/firebird-win64/|here direct link]] )
  
 Each windows package, if desired, can install only client and development files: you are requested to check desired options during .exe installation. Each windows package, if desired, can install only client and development files: you are requested to check desired options during .exe installation.
Line 73: Line 73:
   - ''instclient i f''   - ''instclient i f''
  
-==== Building php_interbase.dll with VC6 ====+==== Building php_interbase.dll/pdo_firebird.dll with Visual Studio 20xx ==== 
 +I have wrote the steps in compiling php_interbase.dll with using the Firebird 2.5.x binaries [[http://mapopa.blogspot.com/2009/09/building-firebird-extension-for-php-53x.html | here ]] but if you want to debug the Firebird client dll or the engine you should follow the steps bellow (requires Firebird 2.5.x compilation also php 5.x.x compilation using the same runtime to be possible a correct debug environment)
  
-(TbD) +  - Install the Visual Studio 20xx  and the required Windows SDK described in these steps [[internals:windows:stepbystepbuild|Windows Build, step by step]] and build your own php 
-==== Building php_interbase.dll with VC9 ==== +  - Download Firebird 2.5.x Final source code [[http://www.firebirdsql.org/en/firebird-2-5 | Firebird-2.5.5.26952-0.tar.bz2 ]]. Open it and extract it with [[http://7zip.org | 7zip]] somewhere in C:\Firebird2.5_src
-I have wrote the steps in compiling php_interbase.dll with using the Firebird 2.5 binaries [[http://mapopa.blogspot.com/2009/09/building-firebird-extension-for-php-53x.html | here ]] but if you want to debug the Firebird client dll or the engine you should follow the steps bellow (requires Firebird 2.5.x compilation also php 5.3.x compilation using the same runtime to be possible a correct debug environment) +
- +
-  - Install the Visual Studio 2008  and the required Windows SDK described in these steps [[internals:windows:stepbystepbuild|Windows Build, step by step]] and build your own php +
-  - Download Firebird 2.5 Final source code [[http://www.firebirdsql.org/index.php?op=files&id=engine_250| Firebird-2.5.0.26074-0.tar.bz2 ]]. Open it and extract it with [[http://7zip.org | 7zip]] somewhere in C:\Firebird2.5_src+
        
-Read how to build Firebird with Visual Studio 2008 http://firebird.svn.sourceforge.net/viewvc/firebird/firebird/trunk/doc/README.build.msvc.html+Read how to build Firebird with Visual Studio 20xx https://github.com/FirebirdSQL/firebird/blob/master/doc/README.build.msvc.html
   - Download [[http://sourceforge.net/projects/gnuwin32/files/sed/4.2-1/sed-4.2-1-setup.exe/download|Sed setup]] from [[http://gnuwin32.sourceforge.net/packages/sed.htm|GnuWin32 project]] I had to run the setup and i extract into c:\gnuwin32    - Download [[http://sourceforge.net/projects/gnuwin32/files/sed/4.2-1/sed-4.2-1-setup.exe/download|Sed setup]] from [[http://gnuwin32.sourceforge.net/packages/sed.htm|GnuWin32 project]] I had to run the setup and i extract into c:\gnuwin32 
   - Add sed c:\gnuwin32\bin to the PATH environment variable , test it from a new console if it works by typing sed it should show you something abut gnu sed help   - Add sed c:\gnuwin32\bin to the PATH environment variable , test it from a new console if it works by typing sed it should show you something abut gnu sed help
-  - Eliminate the fb2control from firebird2 solution if you are using Visual Studio Express (doesn't support MFC) and it's only the control pannel applet and try to build it , it should give you no errors when you build the solution. +  - From cmd in builds\src dir and run in order: make_icu , make_boot , make_all 
-  - From cmd in builds\src dir and run in ord make_icu , make_boot , make_all +
   - If all is ok under output_Win32 you should have the bin folder include and lib , thouse you need to copy them in the php build directory and next you should enable firebird when building it with configure like configure --disable-all --with-interbase --with-pdo-firebird -with-cli   - If all is ok under output_Win32 you should have the bin folder include and lib , thouse you need to copy them in the php build directory and next you should enable firebird when building it with configure like configure --disable-all --with-interbase --with-pdo-firebird -with-cli
   - run nmake and all should compile it and the output of compiler should be in Release_TS (if you get an error about consts_pub.h not found then you might now that you need to comment the line with #include "consts_pub.h" becuase that is a Non-production version of ibase.h Using raw, unprocessed concatenation of header filesand consts_pub.h is already concatenated to the ibase.h file)   - run nmake and all should compile it and the output of compiler should be in Release_TS (if you get an error about consts_pub.h not found then you might now that you need to comment the line with #include "consts_pub.h" becuase that is a Non-production version of ibase.h Using raw, unprocessed concatenation of header filesand consts_pub.h is already concatenated to the ibase.h file)
Line 93: Line 89:
  
      
- 
- 
- 
internals/windows/libs/firebird.txt · Last modified: 2018/01/23 10:17 by mariuz