Hi,
I'm using php on a Netware 6 Server (Apache 2).
Now I try to access a database on this server, but I only have a JDBC
driver for this database for netware.
(ADS 8.1, former "Extended Systems", now "sybase")
What is the easiest way to do this (without JR overhead)?
Ciao
Frank
Micodat schreef:
> Hi,
>
> I'm using php on a Netware 6 Server (Apache 2).
>
> Now I try to access a database on this server, but I only have a JDBC
> driver for this database for netware.
> (ADS 8.1, former "Extended Systems", now "sybase")
>
> What is the easiest way to do this (without JR overhead)?
>
> Ciao
> Frank
Hi Frank,
This is a PHP newsgroup.
Last time I checked Access is M$, and JDBC is Java/Sun.
You might get luckier in:
comp.lang.java.help
As far as I know: you might get lucky using a Sybase driver on MS SQL
Server, but not on Access.
Good luck.
Erwin Moller
Micodat wrote:
> Hi,
>
> I'm using php on a Netware 6 Server (Apache 2).
>
> Now I try to access a database on this server, but I only have a JDBC
> driver for this database for netware.
> (ADS 8.1, former "Extended Systems", now "sybase")
>
> What is the easiest way to do this (without JR overhead)?
>
> Ciao
> Frank
>
I don't do Sybase, but typically you need to load the Sybase client
libraries on the system (they probably already are) and uncomment this
line in your php.ini file:
;extension=php_sybase_ct.dll
(ensure your extensions directory is correct). Finally, stop and
restart your web server.
You can verify if the sybase interface is loaded with phpinfo().
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Hi Erwin & Jerry,
thanx for your answers.
The database ist NOT "Sybase iAnywhere", it's "Sybase ADS", a database
which Sybase bought last year from "Extended Systems", so non of the
sybase php or java drivers will work.
The only driver for netware is a JDBC driver, so I'm looking for a
solution to access a JDBC driver from php for netware.
Ciao
Frank
Micodat schreef:
> Hi Erwin & Jerry,
>
> thanx for your answers.
>
> The database ist NOT "Sybase iAnywhere", it's "Sybase ADS", a database
> which Sybase bought last year from "Extended Systems", so non of the
> sybase php or java drivers will work.
>
> The only driver for netware is a JDBC driver, so I'm looking for a
> solution to access a JDBC driver from php for netware.
>
> Ciao
> Frank
Hi,
Sorry Frank, I see I misinterpreted your first posting, thinking you
needed drivers for MS Access (that silly excuse for a database in MS
Office).
If you ONLY have JDBC drivers to access Sybase ADS, and you need it in
PHP, you might write your solution using Java from PHP:
http://nl3.php.net/manual/en/ref.java.php
I never did such a thing, but I think it can be done relative easily if
your data access needs are humble, eg only basic SQL commands like
SELCTS/UPDATE/DELETE.
If you are going to use SP or more funky stuff, things might get more
complicated.
Let us know if/how you do it. :-)
Regards,
Erwin Moller
On 15 Apr, 08:59, Erwin Moller
> Micodat schreef:
>
> > Hi Erwin & Jerry,
>
> > thanx for your answers.
>
> > The database ist NOT "Sybase iAnywhere", it's "Sybase ADS", a database
> > which Sybase bought last year from "Extended Systems", so non of the
> > sybase php or java drivers will work.
>
> > The only driver for netware is a JDBC driver, so I'm looking for a
> > solution to access a JDBC driver from php for netware.
>
> > Ciao
> > Frank
>
> Hi,
>
> Sorry Frank, I see I misinterpreted your first posting, thinking you
> needed drivers for MS Access (that silly excuse for a database in MS
> Office).
>
> If you ONLY have JDBC drivers to access Sybase ADS, and you need it in
> PHP, you might write your solution using Java from PHP:
>
> http://nl3.php.net/manual/en/ref.java.php
>
That's a scary way to make your your application run like a dog. Java
startup/shutdowns are long and expensive. If this is the only route,
then a better way to implement it would be to create a J2EE app
providing a webservice type interface to the database.
And you're running it on Netware? So it's a NAAPH architecture? Oh
dear.
According to the Sybase website, they provide a PHP connector:
http://www.sybase.com/products/databasemanagement/advantaged atabaseserver/php-extension
or even a C library:
http://www.sybase.com/products/databasemanagement/advantaged atabaseserver/client-engine-api
(as well as a Windows only ODBC driver)
The least painful solution would be to switch OS and/or database
platforms.
No, really.
C.
Micodat wrote:
> Hi Erwin & Jerry,
>
> thanx for your answers.
>
> The database ist NOT "Sybase iAnywhere", it's "Sybase ADS", a database
> which Sybase bought last year from "Extended Systems", so non of the
> sybase php or java drivers will work.
>
> The only driver for netware is a JDBC driver, so I'm looking for a
> solution to access a JDBC driver from php for netware.
>
> Ciao
> Frank
>
Ah, OK, Frank. I didn't realize they bought another database.
I agree with Erwin. If all you have is drivers for JDBC, it looks like
you're going to have to write a bridge so you can use the JDBC library
from PHP.
Alternatively, you could write a PHP extension to access the database.
I assume, anyway, that they have a C/C++ interface to it.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================