connect to 2 DBs/2 informix servers to execute sql

[keenamateur]

i have succeeded to connect to an informix db, run queries, and return the results as required.

could anyone advise how to accomplish a simultaenous connect to run a query against two DBs on two ifx servers in php? (using php.exe on w2k)

any help greatly appreciated

 

[sleipnir214]

I'm not sure exactly what you mean by "simultaneous connect".

You should be able to run ifx_connect() twice, once to connect to each server, and store the connection handles in variables.

Then use the individual db-connect handles stored in their appropriate variables to query the servers.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[keenamateur]

thanks sleipnir214 for your feedback - i have to admit though that i did not fully understand what is meant with "...then use individual db-connect handles ....to query....".
below i put some code typical of what i would like to accomplish - assuming that tbl_a is on server1 and tbl_b on server2 could you possibly point me in the right direction?

...
$conn1 = ifx_connect("server1", "user1", "passwd1&quot or die("bye"
$conn2 = ifx_connect("server2", "user2", "passwd2&quot or die("bye"

$sql =
"select tbl_a.fld_1, tbl_a.fld_2, tbl_b.fld_1
from tbl_a, outer tbl_b
where tbl_a.fld_1 = tbl_b.fld_1"

??? $sql_result = ifx_query($sql,$conn1) or die("bye"

ifx_htmltbl_result($sql_result,"border=0"
ifx_free_result ($sql_result);
ifx_close($conn1);
...

how would the line with the definition of $sql_result have to be changed to reflect that the sql uses both connection vars? or am i on a completely wrong track?

 

[sleipnir214]

PHP isn't going to do what you're trying to do. I doubt any programming language can. Joins must be handled within a database server, not by a programming language. I'm not familiar at all with Informix. Can it perform joins to tables that do not reside on that server?

What I was talking about is creating individual connections to the two servers, then querying one server for some data, then using that fetched data to create queries to be sent to the second server.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!