How to Use Accpac Accounts Receivable in MS DOS
If you use the Sage ERP Accpac software to handle your accounts, then it will utilize the Pervasive.SQL database, the Microsoft SQL Server ot the Oracle Database Server. If you have previously used the early editions of the Accpac software, which utilized the Microsoft Disk Operating System (MS-DOS), then you may prefer to use DOS for retrieving your accounts now. In this instance, you can do so by accessing the database. Accessing these will depend on the database type in use. You cannot access Pervasive.SQL through a DOS window.
Other People Are Reading
Instructions
-
-
1
Open your Command Prompt, if you want to emulate DOS, by clicking "Start," then typing "cmd" and pressing "Enter."
-
2
Type "mysql -h HOSTNAME -u USERNAME -p" (replacing HOSTNAME and USERNAME appropriately), to enter a MySQL database. Press "Enter," type your password and hit "Enter" again. Type "SELECT DATABASE" and enter to view your databases. Type "SHOW TABLES;" to show the tables. Use "DESCRIBE tablename," replacing tablename with a name of a table, to view the data for that account.
-
-
3
Type the following if you are using an Oracle database, "DB2 SELECT * FROM table" (without surrounding quotes). Replace "table" with the table that you want to open from your accounts. Press "Enter."
-
1
References
More Like This
Comments
-
This article is a useless pile of @#$@#$. I've been using and installing Accpac for 22 years, including the DOS days, and it has never used mySQL.
