No fun with ODBC and Sybase

From: Date: Tue, 28 Nov 2000 00:12:14 +0000
Subject: No fun with ODBC and Sybase
Groups: php.db 
Request: Send a blank email to php-db+get-4791@lists.php.net to get a copy of this message
Hello, we try to configure php3 /4 with odbc-support (on a linux box) to access a Sybase SQL Server 11.9.2 Database. For this, we bought an ODBC-Driver fpr Linux from Sybase but this doesn't works together with PHP (even Sybase Support wasn't able to help us). We tried to compile it with --with-custom-odbc but this requires an odbc.h file which wasn't supplied by Sybase. After some discussion we got one, but not specially for an ASE Database but a general one. Well we tried with this and got the same problem like befor. Formally (Compile etc.) everything was allright, but after we started apache it disapeared after some seconds, without writing any log entry or errormsg. Well, after this we tried to connect to the database using the iodbc-manager. We thought we coul use the manager and configure it to work proper with the driverlibrary. Compiling etc. was no problem, and also does the apache process stay alive, but every PHP-Script connecting to the database returns an empty document. Not empty like showing nothing, but really empty (the returned file size is 0 byte). As an Alternative, I thought about OpenLink - Driver. BUt I do not know (and also not understand from the documentations I read) how to use this. I thought, that Sybase-CT Lib is something completly different to ODBC, but if I search the Driverarea of OpenLink for ODBC - Drivers for Linux and Sybase I get only an SDK for Sybase CT. Can I use this and if so, how? Should I compile PHP with --with-iodbc or with --with-openlink? And for all the OpenLink Guys in this Group: What would it cost to use the OpenLink Driver? If anyone knows anything about the problems I describe, please post your opinion or experience about this. Thanks, Stefan Siefert Global Media GmbH

« previous php.db (#4791) next »