No, I'm referring to the .db file itself.
I've identified one problem... it's a 64 bit system, and all the drivers are 32 bit. So, I had to link to the 32 bit odbc driver administrator to see the Micros ODBC drivers.
I *think* the answer is goign to involve setting up a 64 bit obdc system...
Hi all,
We've just taken our first set of Micros Res 5.0 systems, and now my connection string seems to be broken.
This is on a new system, running Windows Server 2008 R2 and the new Micros Database runnign on SQL Anywhere 11 as well.
From what I have found out about it online, it appears as...
Wildbar,
Thanks for the input as well. No, it is a standard issue that all restaurants should be facing if they are pouring alcohol. In our case, it is for multiple brand name concepts and all of them have the same basic configuration. The system was configured by the experts at Micros, and...
This is basically the solution that I came up with as well. The missing piece for me was the lack of the trans_dtl.type. Once I had that, I could link like you were showing. Thanks for verifying my analysis!
Thanks Megan, I figured that I had it...
I included mi_dtl.price_lvl and chk_dtl.rvc_seq the other key seemed to be that I needed to join out on the dtl_type and transaction type
The system was set up so that the rvc_mlvl_temp table has the pricing for Regular, Up, Rocks, and Double (from the...
I'm having some problems joining the Ticket Information back to the Menu Item and ultimately back to the mlvl_type to determine the volume of a pour. The rvc_mlvl_temp has two categories "M" and "S" for the mlvl_type. That difference is preventing me from joining the menu item to its mlvl...
3700SIMComp_man is not in the directory. We also checked on several of the deployed systems to no avail. I found a copy online, but am still following up with Mircos to get a legit copy. I do not have installation disks or anything else, as the systems were set-up by our rep/vendor/reseller...
Thanks, that has started me in the right direction!
Now, since I get to learn this scripting language, does anyone have a copy of the 3700 System Interface Module (SIM) User’s Manual? I found the SIMHelp.chm and the other generic documentation right where it is supposed to be, but no luck on...
Hello all!
I'm new here, and have recently been thrown into the deep end of the pool with assisting on writing an application to allow us to clock employees into micros from an external source.
What we need to do is :
1. Create a tool to allow us to open an external website (the pay tracking...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.