OpenDBX/Setup/Windows/Building with MinGW - Revision history

Nose: reordered backends

2009-08-30T16:20:38Z

reordered backends

2009-08-30T16:17:07Z

Oracle

2009-08-30T16:04:05Z

Sybase

2009-08-30T15:51:43Z

mssql + odbc

2009-08-30T15:43:53Z

firebird

2009-08-30T14:38:42Z

toc

2009-08-30T14:36:55Z

SQLite

2009-08-30T14:01:32Z

PostgreSQL

2009-08-30T13:46:54Z

‎MySQL

2009-07-07T18:00:34Z

MySQL backend instructions for Win32

@@ Line 34: / Line 34: @@
 All backends could be build invoking ./configure like shown below. Please keep in mind that the paths may differ depending on the location of the installed packages:
 === MySQL ===
@@ Line 53: / Line 69: @@
   LDFLAGS="-L/c/Progra~1/MySQL/MySQLS~1.1/lib/opt" \
   ./configure --with-backends="mysql"
 === PostgreSQL ===
@@ Line 76: / Line 110: @@
   LDFLAGS="-L/c/local/lib"
   ./configure --with-backends="sqlite3"
 === Sybase ===
@@ Line 108: / Line 120: @@
 The path to the directory where the Sybase files are installed depends on your choice during the installation process. Please adapt it to your needs.

@@ Line 109: / Line 109: @@
 The path to the directory where the Sybase files are installed depends on your choice during the installation process. Please adapt it to your needs.
-=== Other ===
+=== Oracle ===
-  CPPFLAGS=" \
+Building the oracle backend requires one of the product editions available from the [http://www.oracle.com/database/index.html Oracle website] which contains the include and DLL files. After installing the package on your machine you have to rename the file
-  -I/c/Progra~1/Oracle/product/11.1.0/instantclient_11_1/sdk/include \
- " \
+ oci.lib to liboci.dll
-  LDFLAGS=" \
-  -L/c/Progra~1/Oracle/product/11.1.0/instantclient_11_1 \
+in the "lib" directory to enable autoconf and libtool to find the library. You may find the "lib" directory somewhere below the directory where you've installed the Oracle files. Depending on that, you have to adapt the paths in the command for building the backend:
- " \
-  ./configure --with-backends="mssql odbc oracle sqlite3 sybase"
+  CPPFLAGS="-I/c/Progra~1/Oracle/product/11.1.0/instantclient_11_1/sdk/include" \

@@ Line 98: / Line 98: @@
   ./configure --with-backends="odbc"
 === Other ===
   CPPFLAGS=" \
    -I/c/Progra~1/Oracle/product/11.1.0/instantclient_11_1/sdk/include \
   " \
   LDFLAGS=" \
    -L/c/Progra~1/Oracle/product/11.1.0/instantclient_11_1 \
   " \
   ./configure --with-backends="mssql odbc oracle sqlite3 sybase"

@@ Line 88: / Line 88: @@
   LDFLAGS="-L/c/Progra~1/Firebird/Firebird_2_1/lib" \
   ./configure --with-backends="firebird"
 === Other ===
@@ Line 94: / Line 104: @@
    -I/c/Progra~1/sybase/OCS-15_0/include/ \
    -I/c/Progra~1/Oracle/product/11.1.0/instantclient_11_1/sdk/include \
   " \
   LDFLAGS=" \

@@ Line 76: / Line 76: @@
   LDFLAGS="-L/c/local/lib"
   ./configure --with-backends="sqlite3"
 === Other ===
   CPPFLAGS=" \
    -I/c/Progra~1/sybase/OCS-15_0/include/ \
    -I/c/Progra~1/Oracle/product/11.1.0/instantclient_11_1/sdk/include \
@@ Line 86: / Line 97: @@
   " \
   LDFLAGS=" \
    -L/c/Progra~1/sybase/OCS-15_0/dll \
    -L/c/Progra~1/Oracle/product/11.1.0/instantclient_11_1 \
   " \
   ./configure --with-backends="mssql odbc oracle sqlite3 sybase"

← Older revision		Revision as of 14:38, 30 August 2009
Line 1:		Line 1:
	MinGW is a collection of freely available and freely distributable Windows specific header files and import libraries, augmenting the GNU Compiler Collection, (GCC), and its associated tools, (GNU binutils). MinGW provides a complete Open Source programming tool set which is suitable for the development of native Windows programs that do not depend on any 3rd-party C runtime DLL.		MinGW is a collection of freely available and freely distributable Windows specific header files and import libraries, augmenting the GNU Compiler Collection, (GCC), and its associated tools, (GNU binutils). MinGW provides a complete Open Source programming tool set which is suitable for the development of native Windows programs that do not depend on any 3rd-party C runtime DLL.
		+
		+	__TOC__
		+
		+	== Requirements ==

	Download the following packages from the [http://sourceforge.net/project/showfiles.php?group_id=2435 MinGW Sourceforge] page:		Download the following packages from the [http://sourceforge.net/project/showfiles.php?group_id=2435 MinGW Sourceforge] page:

@@ Line 57: / Line 57: @@
   LDFLAGS="-L/c/Progra~1/Postgr~1/8.4/bin" \
   ./configure --with-backends="pgsql"
 === Other ===

@@ Line 49: / Line 49: @@
   LDFLAGS="-L/c/Progra~1/MySQL/MySQLS~1.1/lib/opt" \
   ./configure --with-backends="mysql"
 === Other ===
   CPPFLAGS=" \
    -I/c/Progra~1/Firebird/Firebird_2_1/include/ \
    -I/c/Progra~1/sybase/OCS-15_0/include/ \
@@ Line 60: / Line 67: @@
   " \
   LDFLAGS=" \
    -L/c/Progra~1/Firebird/Firebird_2_1/lib \
    -L/c/Progra~1/Firebird/Firebird_2_1/bin \
@@ Line 67: / Line 73: @@
    -L/c/Progra~1/GnuWin32/lib \
   " \
-  ./configure --with-backends="mssql odbc oracle pgsql sqlite3 sybase"
+  ./configure --with-backends="mssql odbc oracle sqlite3 sybase"

@@ Line 40: / Line 40: @@
 Otherwise, the libmysql.dll file isn't installed in the "bin\" directory and the files in the "include\" and "lib\opt\" directory are not available.
-The OpenDBX MySQL backend doesn't build out of the box as the mysql.h file is not prepared to be used with MinGW. Fortunately, applying a simple hack to the mysql.h file does fix the problem: Change the line
+Autoconf and Libtool seem to have problems finding the "mysql.lib" file in the "lib\opt\" directory. As a workaround, you have to rename the file
-  #ifdef __CYGWIN__
+  mysql.lib to libmysql.dll
-−
-to
-−
- #ifndef __CYGWIN__
-−
-and you are able to use the mysql.h file for compilation. Otherwise, you will get a lot of error messages.
 The call to the ./configure script depends on the location of the files. The paths below are for MySQL 5.1 and if you've installed a different version or installed it to a different path, please adapt the paths as necessary. Especially the "MySQLS~1.1" part has to be changed for different versions of the MySQL package.
-  CPPFLAGS=" \
+  CPPFLAGS="-I/c/Progra~1/MySQL/MySQLS~1.1/include/" \
-  -I/c/Progra~1/MySQL/MySQLS~1.1/include/ \
+  LDFLAGS="-L/c/Progra~1/MySQL/MySQLS~1.1/lib/opt" \
- " \
-  LDFLAGS=" \
-  -L/c/Progra~1/MySQL/MySQLS~1.1/bin \
-  -L/c/Progra~1/MySQL/MySQLS~1.1/lib/opt \
- " \
   ./configure --with-backends="mysql"