Hello all,
So i have an issue...I do not how to go about. I have two databases on two different servers using MSSQL 2k. I need to update a table Server2.DB2.TableX from Server1.DB1.TableX. No i know this can be done by cross referencing databases in MySQL, but is this possible using ODBC connections to MSSQL 2k? Also, I know how to create the query...something like the following:
$query = "UPDATE DB2.TableX tblX2 FROM DB1.Tablex tblX1 WHERE tblX1.name = tblX2.name";
I am not sure though my syntax is 100% correct, but assuming it is, what do i do next? Usually I query this towards a database, I.E. the follwoing:
$DBresult = odbc_exec($DB1_conn, $query);
My question is... since the query uses 2 different databases which database do I use this querry on? Or is it the case that if databases are already connected to I only execute the following:
$DBresult = odbc_exec("",$query);
? any help is apreciated !
-Horia
