RE: [PHP-DB] No fun with ODBC and Sybase From: Andrew Hill (ahill <email protected>)
Date: 11/28/00

Hi Stefan,

If you have compiled with iODBC than you should be able to to use any ODBC
driver available, with the iODBC driver manager. IF your existing driver is
having problem and you wish to try the Openlink driver, you can download it
at www.openlinksw.com/

Select the Product Availability link, Multi-Tier, and then choose the
server, client, and database. You will need to install components on both
client and server machine. Also, be sure that you pass the environment
variables specified in openlink.sh in to the PHP script before trying to
connect.

Free support is available at http://www.openlinksw.com/support/suppindx.htm
if you need assistance.

There is a HOWTO at http://www.iodbc.org on PHP-ODBC that may prove helpful.
It does state that you should use --with-openlink instead of --with-iodbc if
using our drivers, but that is not necessary any longer.

Best regards,
Andrew
----------------------------------------------------
Andrew Hill
Director Technology Evangelism
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider

> -----Original Message-----
> From: Stefan Siefert [mailto:s.siefert <email protected>]
> Sent: Monday, November 27, 2000 7:12 PM
> To: PHP Mailingliste
> Subject: [PHP-DB] No fun with ODBC and Sybase
>
>
> 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
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>