#23541 [Opn->Asn]: ODBC: Support for picoSQL database

From: Date: Thu, 08 May 2003 16:00:38 +0000
Subject: #23541 [Opn->Asn]: ODBC: Support for picoSQL database
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-39316@lists.php.net to get a copy of this message 
 ID:               23541
 Updated by:       wez@php.net
 Reported By:      marco at picosoft dot it
-Status:           Open
+Status:           Assigned
 Bug Type:         Feature/Change Request
 Operating System: all
 PHP Version:      4.3.1
-Assigned To:      
+Assigned To:      wez
 New Comment:

Patch needs some changes before applying to current CVS.



Previous Comments:
------------------------------------------------------------------------

[2003-05-08 03:01:18] marco at picosoft dot it

I would like to propose the picoSQL db support in PHP.
picoSQL supports the ODBC APIs, so you need to change only
the following two files (you can get further informations
at www.picosoft.it/picosql or you can email me):

--- php-4.3.1/ext/odbc/php_odbc_includes.h      Wed Jul 31 15:51:20
2002
+++ php-4.3.1/ext/odbc/php_odbc_includes.h.new  Wed Apr 30 17:04:45
2003
@@ -179,6 +179,12 @@
 #include <LibraryManager.h>
 #endif

+#elif defined(HAVE_PICOSQL) /* PICOSQL */
+#define ODBC_TYPE "picoSQL"
+#define HAVE_SQL_EXTENDED_FETCH 1
+#include <odbcsql.h>
+# define SQL_MAX_MESSAGE_LENGTH 512
+
 #else /* MS ODBC */

 #define HAVE_SQL_EXTENDED_FETCH 1


--- php-4.3.1/ext/odbc/config.m4        Tue Nov 12 18:31:39 2002
+++ php-4.3.1/ext/odbc/config.m4.new    Wed Apr 30 16:50:00 2003
@@ -534,6 +534,36 @@
 ])
 fi

+if test -z "$ODBC_TYPE"; then
+AC_MSG_CHECKING(for picoSQL support)
+AC_ARG_WITH(picoSQL,
+[  --with-picoSQL[=DIR]   Include picoSQL support.  DIR is the
+                          picoSQL base install directory, defaults to
+                          /usr/local.],
+[
+  PHP_WITH_SHARED
+  if test "$withval" = "yes"; then
+    withval=/usr/local
+  fi
+  if test "$withval" != "no"; then
+    PHP_ADD_LIBRARY_WITH_PATH(picocpp, $withval/lib)
+    PHP_ADD_LIBRARY_WITH_PATH(picoiiop, $withval/lib)
+    PHP_ADD_LIBRARY_WITH_PATH(picosqlnet, $withval/lib)
+    PHP_ADD_INCLUDE($withval/inc, 1)
+    ODBC_TYPE=picoSQL
+    ODBC_INCLUDE=-I$withval/inc
+    ODBC_LFLAGS=-L$withval/lib
+    ODBC_LIBS=-lpicosqlnet -lpicoiiop -lpicocpp
+    AC_DEFINE(HAVE_PICOSQL,1,[ ])
+    AC_MSG_RESULT(yes)
+  else
+    AC_MSG_RESULT(no)
+  fi
+],[
+  AC_MSG_RESULT(no)
+])
+fi
+
 if test -n "$ODBC_TYPE"; then
   if test "$ODBC_TYPE" != "dbmaker"; then
     if test "$shared" != "yes"; then

------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=23541&edit=1

Thread (4 messages)

« previous php.bugs (#39316) next »