Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSDHosts

Status
Not open for further replies.
chevell

chevell

Technical User
Jul 2, 2010
34
US
Hey guys,
I've got no experience with POS Systems, but a client asked me to make a custom web app that interfaces with his POS. I obviously don't want to develop on his server, so he gave me his CDs to install in a VM in demo mode. Everything installed without issue and I have the license manager running in demo mode.

When I click the Start RES app, it pops up the application starter and sits at "Wait for MDSHosts". I have no idea what that means and can't find any reference to it. Any help would be greatly appreciated!
 
Sort by date Sort by votes
You will have an issue in that OPS will not update in real time. I tried to do this with an installer from MICROS, in my case i was trying to create Menu item SLU's on the fly in a SIM, and the response from R&D is that OPS will only refresh in set intervals, and those intervals are not user defined. I believe in older versions there was a registry entry that would allow this, but changing data in a transaction real time. I am not sure what your "App Server" is, I may have missed when reading through all the past posts, but in our case we are using SSIS to change data and get real time updates. We battled for awhile with the ODBC drivers, but found we could simply install Sybase ASA 9.0 on our server, it is a bit overkill but you need the DLL's that are contained in the install. I could not use ourMICROS disks because our SQL server was 64-bit. This way we can loop through all of our stores in one contained program. You could update prices every minute, hour, day.

 
Upvote 0 Downvote
I'm ok, with it updating every minute, or so, I just want the transaction to take place in one SIM script. I actually can communicate with my server via ODBC right now, so that's not an issue, but I was planning on letting the server connect to my SQL server. I'm leaning towards MySQL, due to costs, among other things. So what I'm looking at doing is feasible, I just need to see if there are any examples out there of what i need to do. Shouldn't have to reinvent the wheel here. Thanks!
 
Upvote 0 Downvote
If you were doing a timed update, you could handle all the SQL on the backend through DBISQL rather than using SIM. That is if the SIM function was to only update the price.

Another option is to program an item with an open price, when this item is rung in, than using a SIM query, connect to your server, get the price. The price is then returned to a variable which will then be keyed in as the price. Therefore, there is no "price" record to update in MICROS.

If you were to use the second option of an open price, the evnt that triggers the sim would be a bit of fun. You could use the MI event and look at the last item entered, if it is an item that you feed a price to, perform the query void the item then re-ring it with the correct price.

All thoughts, untested, would be glad to try it if you are thinking about this method.
 
Upvote 0 Downvote
Hmmm, all interesting ideas. I'm trying to make this as simple as possible, with as little communication as possible. I just need to get a working proof of concept up and then we can bring in someone who actually knows this environment and add on all sorts of other features. THIS, however is the main event.

I'm not even sure that the way that we get it working will be the way that we do it going forward. So basically, the easiest way to do what i need to do right now will work.

SIM sounds like its going to be the best place to work out of, if only just to execute the SQL DLLs mentioned in the SIM programming guide.
 
Upvote 0 Downvote
If you would like, I can help you write the SIM, and try basic functionality. Do you have a template to work off of, if not I can provide you one. Beats typing it all in notepad.
 
Upvote 0 Downvote
nope, never worked in this area before. I was just reading the SIM documentation and really just need a starting point. I would really appreciate any help you can give. Thanks!
 
Upvote 0 Downvote
- call me and we can work out some time, I am open for awhile yet tonight

I can show you some working exaples of SIM working against the MICROS db, then we should beable to use the connsction string for yours and do the same thing
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top