remote dBase

[zaulys]

Problem is:

          server1                                             server2
 dBase+apache+php---------------------apache+php+posgre

I need to get some data from dBase database and put to postgre database.

  How can I connect to dBase from server2 and get data I need?

   Thanks for help

[jowatkins]

I thought that assuming you have grant rights on the db you can access it from anywhere.

$DatabaseName = "dbname"; //select db
$DbHostName = "address: port"; //set db address
//set db user & pword
$DbUserName = "user";
$DbPassWord = "password";

mysql_connect("$DbHostName", "$DbUserName", "$DbPassWord");
mysql_select_db("$DatabaseName") or die ("Unable to connect to SQL Server");

[zaulys]

🙂

Problem is that dBase database is not MySQL database