HOW TO POPULATE AN EMPTY SERVER DB

2/04/2017

COPYRIGHT 2002 thru 2017 - David R. Woodsmall

1] First ensure that TestApp is NOT running. 2] Copy the empty database file: WCD\Software Lifecycle\Source\Src\ADEDatabase\ADESQLDB.mlb to directory: WCD\Software Lifecycle\Source\Src\LoadADEDatabase\Release 3] Change the file Property from read only to read/write (uncheck the read only box). 4] Ensure that WCD\Software Lifecycle\Source\Src\LoadADEDatabase\Release\LoaderFile.txt contains the IP addresses that you need. 5] Get a DOS Window and runs steps 6 and 7 in the DOS window: 6] CD WCD\Software Lifecycle\Source\Src\LoadADEDatabase\Release 7] LoadADEDatabase LoaderFile.txt (this populates the empty DB) 8] Then, using Windows, copy the database into the appropriate TestApp folder: copy file: WCD\Software Lifecycle\Source\Src\LoadADEDatabase\Release\ADESQLDB.mlb paste into folder: WCD\Software Lifecycle\Source\Src\TestApp\Release 9] NOTE: If you are going to run TestApp in the DEBUG mode NOT from MSDN, copy file ADESQLDB.mlb to the "TestApp\Debug" directory (as debug looks in this directory): WCD\Software Lifecycle\Source\Src\TestApp\Debug 10] NOTE: If you are going to run TestApp in the DEBUG mode FROM MSDN, copy file ADESQLDB.mlb to the "TestApp" directory (as debug looks in this directory): WCD\Software Lifecycle\Source\Src\TestApp

FASTER METHOD

1] If WCD\Software Lifecycle\Source\Src\LoadADEDatabase\Release\ADESQLDB.mlb has already been correctly populated, simply copy the file to: folder: WCD\Software Lifecycle\Source\Src\TestApp\Release or to the appropriate folder if using DEBUG 2] NOTE: If you are going to run TestApp in the DEBUG mode, copy file ADESQLDB.mlb to the "TestApp" directory (as debug looks in this directory): WCD\Software Lifecycle\Source\Src\TestApp

NOTE: You will probably also want to:

1) Run RemoveRecord on the Client (if you have the software). This program will empty the WMSInbox. If you do not have this software, you must manually delete each entry in the WMSInbox by holding the stylus down on the item, then selecting "Delete". 2) Manually remove all files in the WMS folder on the Client, using: START PROGRAMS FILE EXPLORER Select the WMS folder under My Documents (program shows: My Documents) Manaually delete each file by clicking (long time) on each file, then selecting DELETE.

SAMPLE DOS EXECUTION of: LoadADEDatabase LoaderFile.txt

C:\Build_5_24_02\WCD\Software Lifecycle\Source\Src\LoadADEDatabase\Release>LoadA DEDatabase LoaderFile.txt Inserted New Device OS: WinCE Inserted New Device OS Version: 1.0.1 Inserted New Subscription Unit: WCD Subscription Inserted New Manufacturer: The Manufacturer Inserted New Device Model Inserted New ModemModel Inserted New User, Modem, Device Inserted New User, Modem, Device Inserted New User, Modem, Device Inserted New User, Modem, Device Inserted New User, Modem, Device Inserted New User, Modem, Device Inserted New User, Modem, Device Inserted New User, Modem, Device Inserted New User, Modem, Device C:\Build_5_24_02\WCD\Software Lifecycle\Source\Src\LoadADEDatabase\Release>
  • Acronyms / Glossary
  • DATABASE Info
  • My MAIN Web Page