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!

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

Recent content by FreeSoldier

  1. FreeSoldier

    Micros SQL Queries

    Hi All, I have an SQL queries that will list all the employees with their job(s) and pay rate. select e.obj_num as "Payroll ID", e.long_first_name as "First Name" , e.long_last_name as "Last Name" , j.name as "Job Name" , COALESCE(h.override_reg_pay_rate, j.deflt_reg_pay_rate) as 'Pay...
  2. FreeSoldier

    Server 2012 R2 VPN Encryption

    Hi, Our 2012 R2 Windows Server is setup to accept VPN connection via the "Routing and Remote Access" Tool. We currently only accept L2TP and IKEv2 VPN Connections with a Preshared Key Setting. Since our business accepted credit cards, we are required to run a PCI scan via trustwave.com...
  3. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Regis M., Apologies for the late answer but downloading the sql Anywhere 17 drivers and setting up the connection did the trick. Many Thanks. FreeSoldier
  4. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Thanks again Regis. It looks like Micros installation does not add any of the 64 bits drivers. When I tried to follow you suggestion I could not find the "SQL Anywhere 16" drivers under ODBC (64 bits) they are only listed under ODBC (32 bits). Any idea where I can download the "SQL Anywhere 16"...
  5. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Good Morning Folks, Any Excel 64-bits/Micros DB expert in house that could assist? Thanks in advance. FreeSoldier
  6. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Thanks for the suggestion Regis. Under Windows 10 Pro, when I go to the Control Panel -> Administrative Tools and i look under both "ODBC Data Sources (32-bit)" and "ODBC Data Sources (64-bit)", the Micros DB is listed under both modules under the "System DSN" tab with Name=Micros...
  7. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Update: So it turns out the Office 365 version I installed was the 64 bits one. My Office 2010 is the 32 bits one. So I installed Office 365 32 bits version and now I can see the Micros* DB in Excel from the Data Tab, Get Data -> From Other Sources -> From Microsoft Query. Does anyone...
  8. FreeSoldier

    Micros DB Access via Excel 365 / Windows 10 Pro

    Hi all, We are in the process of migrating our back office PCs to Windows 10 Pro/Office 365. We are currently running under Windows 7 Pro/Office 2010. We also recently upgraded our Micros 3700 to version 5.6 MR1. I ran WIN Cal on one of the new Windows 10 Pro PC and successfully installed...
  9. FreeSoldier

    Micros / Shift4 EMV Solution

    Hi All, We are currently looking at upgrading our current Micros 3700 installation to an EMV solution. Our current Micros Rep has recommended Shift4. Anyone is using them ? Any pros/cons ? Any other provider that we should consider for EMV? Any feedback will be much appreciated. Cheers...
  10. FreeSoldier

    micros 3700 5.5 error

    Hi maxp, Make sure your computer name and the name in the Pos Configurator/Network Node matches (same character capitalization). If they don't, the the license will not work. Best FreeSoldier
  11. FreeSoldier

    Decrypting micros ISL Files...

    Request sent as well. Thanks
  12. FreeSoldier

    Micros RES 3700 - Is the "Time Fire" Function accessible via SIM/ISL ?

    Hi all, Anyone knows if the "Time Fire" Function:Transaction in Micros RES 3700 can be accessed inside a SIM/ISL. If it is, would you happen to known what is the corresponding key_pair for the Key() Function that can be used inside a SIM/ISL to access it ? Many Thanks FreeSoldier
  13. FreeSoldier

    Micros 3700 - Item Sales SQL Query

    Bufftrek, The best solution is to create menu items called Rocks, Double etc that have required condiments. So when you click on Double it will prompt you for a spirit selection. Note that the required condiments have to be different for Rocks and Double unless your pouring size is the same...
  14. FreeSoldier

    Automatic Calculation of Banquet Fees

    Thanks Wildbar. Because of Labor Law and IRS Regulation regarding tips and service charges, Banquet Fees can not be posted as service charge since the same account is used to post all the tips. The banquet fee has to be a line item by itself on the check and can not be combine with anything...

Part and Inventory Search

Back
Top