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

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • breakaway
    New Member
    • Feb 2007
    • 4
    #1

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

    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.
    Tags: None
    • breakaway
      New Member
      • Feb 2007
      • 4
      #2
      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.

        Comment

        • cassbiz
          New Member
          • Oct 2006
          • 202
          #3
          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

            Comment

            • breakaway
              New Member
              • Feb 2007
              • 4
              #4
              Originally posted by cassbiz
              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...

                Comment

                • breakaway
                  New Member
                  • Feb 2007
                  • 4
                  #5
                  Nothing I can find would suggest that Rsync would keep a MsSQL database synced onto another server running MySQL

                    Comment

                    Previous template Next
                    Working...