It can be launched on the micros server by typing DBISQL into the run prompt and pressing OK. See below screenshots.
Micros POS installs usually have then following passwords by default. You may also have been given a DBA password by your micros installer.
Username: custom
Password: custom
or
Username: installer
Password: installer
You may also need to select the ODBC data source name which will be called "Micros" but 99% of the time you wont need to do this. See the image above.
----------------------------------------------
An example of what you expect to be able to see after logging in is shown in the image below.
An example what what an actual query in dbisql looks like is shown in the image below. This query returns the data for all checks in the database.
To search how select, update, inserts and everything to do with SQL works I suggest you google some tutorials so you can get the most out of your micros database.
Does any know where micros gets data for the (External Posting Files)?
ReplyDeleteThere are highly proprietary systems (even if you us a PC to access them) and there is no way to know exactly what your system is running - most many have had specialized software installed. Even if it is the base, completely unaltered Micros, you can't get information on these things without a service account with them.
ReplyDeleteRestaurant Software
do you have the dba password for micros 3700?
ReplyDeletefor me is * Custom *
DeleteI have a question once i force to close the Check because i have ( 9700 - Error: Check Detail Read Failed )
ReplyDeletewhen i close the SQL , everting come back again .
save it ? how..! ?
Getting a "Printer Communication Failure" error message. All cabling has been checked and in good. Any thoughts?
ReplyDeleteI am getting the error "Could not connect to the database. Database Server Not Found"
ReplyDeleteAny ideas?
is SQL service running?
DeleteI am trying to view the reports for daily, weekly and hourly . Is there a way to extract these data from SQL anywhere in to excel or some other format?
ReplyDeletethanks
How i can found micros password
ReplyDeletevery Interesting and useful information epos uk you have shared and keep sharing the blogs....
ReplyDelete