No fun with ODBC and Sybase
| From: | Stefan Siefert | 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