By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,664 Members | 1,669 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,664 IT Pros & Developers. It's quick & easy.

Running a class on a remote machine.....

P: 4
Hi everyone, I have a question regarding executing a few classes I have written on one server from another server. here is the configuration, the server I have which is accessible fromt he internet is a Linux box, running PHP 5. I have a Windows 2000 server on our corporate LAN, running Apache and PHP 5 also, I have a third server on my LAN running SQL Server. I have a huge database with all sorts of data I would like to be able to connect to with the Linux server and post n the internet for customers, employees and our contractors. A lot of the functions to access this data have been written and are published on our Intranet site. I don' want to give access to the Windows Server to people on the internet foor various reasons, and would like provide the access through the Linux server. I have been trying to figure out how the best way to "call' these funtions would be... Maybe by using AJAX, maybe fsockopen, Curl... Any suggestions would be appreciated.


Thanks.
Feb 12 '07 #1
Share this Question
Share on Google+
4 Replies


P: 4
Sorry i forgot to mention the whole purpose of needing to pass through the Windows server is that i don't have the MsSQL server drivers for Linux and the Windows server is all set up to do so.
Feb 12 '07 #2

cassbiz
100+
P: 202
I would suggest exporting the database over to MySQL and you can run rsync to keep the database current. This way the Windows server will not be connected but through your LAN.

Here is a link over to rsync

I had a similar situation and we were using MS Access.

Good Luck
Feb 12 '07 #3

P: 4
I would suggest exporting the database over to MySQL and you can run rsync to keep the database current. This way the Windows server will not be connected but through your LAN.

Here is a link over to rsync

I had a similar situation and we were using MS Access.

Good Luck
Interesting, i thought about trying to set up replication between the two servers. How would RSYNC keep the databases updated? it is used to keep directories and files syncronized correct? I also considered exporting data to MySQL server several times a day, however the call center is changing this data (appointment and dispatch info) all day long and I am afraid people will get out dated data if it is between refreshes...
Feb 12 '07 #4

P: 4
Nothing I can find would suggest that Rsync would keep a MsSQL database synced onto another server running MySQL
Feb 13 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.