Linux ODBC accessing two different DB Systems

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
thomaska
Forum Newbie
Posts: 5
Joined: Thu Jan 23, 2003 1:22 am

Linux ODBC accessing two different DB Systems

Post 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
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

Post 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
thomaska
Forum Newbie
Posts: 5
Joined: Thu Jan 23, 2003 1:22 am

Post 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
Post Reply