Page 1 of 1

Linux ODBC accessing two different DB Systems

Posted: Thu Jan 23, 2003 1:39 am
by thomaska
I tried to access IBM DB and SAPDB from Linux/PHP. It seems that each System occupies the ODBC-Interface exclusiv. Are there any technics to deal with this restriction?

Thomas

Posted: Thu Jan 23, 2003 7:50 pm
by fractalvibes
Try closing the connection to one before opening the connection to the other.

i.e.
open conn to DB2
Do what you need to do
close conn

open conn to SAP
do whatever
close conn

Posted: Fri Jan 24, 2003 1:30 am
by thomaska
It is a bit more difficult: When compiling PHP, the make process takes the first odbc-modules (i. e. SAPDB) and does not compile the others (DB2).

But the SAPDB-ODBC-Modules are not able to work with DB2.

When excluding SAPDB, the DB2-ODBC-Part is included correctly. I guess, they can't work with SAPDB (I did not even find a way to configure such a connection).

Thomas