Page 1 of 1

Heterogenous Environnement

Posted: Sun Nov 27, 2005 1:34 pm
by GOXTECH
Today I have been presented with a new difficulty. Our web server is a Novell box running Apache. Call it a LAMP if you want. I have been requested to develop a PHP application accessing some data in the accounting dep. database. Problem is, the accounting database is a weird, non-relational database called Acomba and is only accessible trough ODBC and DSN under a Win2003 server.

To be honest, I’m stumped on how I’m going to make my php apps "talk" to our windows box ODBC.

I understand that my problem is not “Pure PHP” but if any of you got idea on how to accomplish this or can point me to the right website/article/forum I would really help me.

Thank you for your time.
:D

Re: Heterogenous Environnement

Posted: Sun Nov 27, 2005 2:19 pm
by Roja
GOXTECH wrote: To be honest, I’m stumped on how I’m going to make my php apps "talk" to our windows box ODBC.
http://us2.php.net/manual/en/ref.uodbc.php

Or, if you prefer db-abstraction, and a feature-rich library, use adodb (which supports ODBC as well):

http://adodb.sourceforge.net/

Posted: Mon Nov 28, 2005 9:51 am
by BDKR
Roja has pointed you in the right direction. ODBC isn't really a big deal. Check out the documentation and if it still gives you problems, post back. :)

Cheers