farr433 Posted March 6, 2013 Share Posted March 6, 2013 Hey guys I have been working a project and this is going to be long but I want to explain my problem thoroughly. I have a web hosting server provided by Bluehost and I have been doing my programming with PHP fine and having a lot of fun. However now I have a client that currently has the POS (point of sale) system called MICROS which creates a server and runs the POS. They currently do all of their paperwork in Microsoft Excel by running the reports created by Micros (entirely separate application) and then input the data into excel and there is just a lot of swapping back and forth between the two. I currently am in the process of planning out a way to run an application in the browser to where they put their daily sales into a form I create and then my PHP application automatically goes into the MICROS database and compares automatically then from there populates my Bluehost database. Long story short I need to be able to have my Bluehost database and the Micros database communicate. I am not really sure how to go about this. I can get access to the MICROS .dbase file if that helps any and also I do have a username and password that allows me into the database on MICROS. I don't have experience with the "Sybase Adaptive Server Anywhere" but I did see that on the MICROS computer there is a version of SQLlite driver and heard of that in PHP so I am thinking that is my ticket. I just need a push in the right direction but also the Sybase has a way to set up a web service in the Sybase Central configuration application. I was also thinking that maybe I need to create my php files and then put them on the MICROS system to properly run and somehow link it all together, I don't know guys, HELP! Let me know if there is any other information that needs to be supplied. Technologies involved: Bluehost Linux, MySql, phpMyAdmin MICROS Windows XP, Sybase Adaptive Server Anywhere 9 Link to comment https://forums.phpfreaks.com/topic/275320-server-to-server-database-connections/ Share on other sites More sharing options...
farr433 Posted March 6, 2013 Author Share Posted March 6, 2013 Here is a view of the Sybase Central for the MICROS database. Link to comment https://forums.phpfreaks.com/topic/275320-server-to-server-database-connections/#findComment-1416942 Share on other sites More sharing options...
ahernanh Posted July 19, 2016 Share Posted July 19, 2016 Hellow. I wonder if you manged to build the PHP connection to the micros database? Link to comment https://forums.phpfreaks.com/topic/275320-server-to-server-database-connections/#findComment-1534666 Share on other sites More sharing options...
Jacques1 Posted July 20, 2016 Share Posted July 20, 2016 That was more than three years ago, and the user hasn't been online ever since. Create your own threads, don't hijack or resurrect old topics. Link to comment https://forums.phpfreaks.com/topic/275320-server-to-server-database-connections/#findComment-1534681 Share on other sites More sharing options...
Recommended Posts