Supported Operating Systems

Supported Operating Systems: Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition, Windows 2000 Advanced Server; Windows 2000 Professional Edition ; Windows 2000 Server; Windows Server 2003
-
PC with Intel or compatible Pentium 166 MHz or higher processor
-
Minimum of 64 MB of RAM (128 MB or more recommended)
-
100 MB of available hard disk space for new install of MSDE
In the CD given, there is a folder named ‘MSDE SP4’. Click that folder. You will find a file ‘SQL2000.MSDE-KB884525-SP4-x86-ENU.exe’.
To install MSDE 2000-sp4, double-click that file.
-
Click ‘accept’ the license agreement and click ‘Next’
-
By default, it will show the MSDE installation folder as ‘C:\SQL2KSP4’…click ‘Next’.
-
Now it will extract the files required for installation into a folder ‘MSDE’ in C:\SQL2KSP4 and after installation, it will show ‘Finish’ button. click it.
-
Now through ‘command’ prompt, change the directory to ‘C:\SQL2KSP4\MSDE’.
This can be done through:
Click Start -> Run -> type cmd and press enter-key
Now in the command prompt, type cd C:\SQL2KSP4\MSDE and press enter-key.
-
C:\SQL2KSP4\MSDE>Type setup SAPWD=“sa” SECURITYMODE=SQL
and press enter.
Now it will install Microsoft SQL server Desktop Engine.
-
After installation is over, the system will prompt you ‘to complete the installation, the system must be restarted…whether you want to restart the system now or later’. Click ‘Yes’ to restart the system.
Download & Installation of ‘DbaMgr2k’(MSDE Administrative Tool):
If you installed MSDE, also install the MSDE Administrative Tool ‘DbaMgr2k’. ‘DbaMgr2k’ provide a graphic management interface for MSDE-2000-SP4 installation. It allows you to manage and administer your server, databases and database objects from a Windows interface similar to the one Microsoft Enterprise Manager provides, rather than via the standard oSql.exe command line utility: an alternative inexpensive console/management tool for Microsoft MSDE-2000-SP4.
If you are given a CD (containing the s/w & database required for nrega offline software installation), under the folder ‘MSDE SP4’, there is a folder ‘DBA Manager2k’. Click it. There is an EXE file-name ‘Setup_DbaMgr2k.exe’.
OR
Download ‘DbaMgr2k’ (Setup_DbaMgr2k.exe) from the site:
http://www.snapfiles.com/get/dbamgr2.html
To install ‘MSDE Administrative Tool’, double click ‘Setup_DbaMgr2k.exe’ file.
-
It will show a screen ‘select the Setup language’. By default it will show ‘English’. You just click the ‘OK’ button.
-
Now the screen shows the ‘Welcome to the Dba2kMgr2k Setup Wizard’. Click ‘Next’ button.
-
Now the screen shows the ‘License Agreement’. Click ‘I agree the agreement’ and click Next’ button.
-
Now the screen shows some information. Click ‘Next’ button.
-
Now the screen shows the ‘Select Destination Location’. By default, it will show ‘C:\Program Files\DbaMGR2k’. Click ‘Next’ button.
-
Now the screen shows the ‘Select Components’. By default it will show ‘Full Installation’. Click ‘Next’ button.
-
Now the screen shows the ‘Select Start Menu Folder’. By default it will show ‘DbaMGR2k’. Click ‘Next’ button.
-
Now the screen shows the ‘Select Additional Tasks’. By default, both the items ‘Create a desktop icon’ and ‘Create a Quick Launch Icon’ are checked. Click ‘Next’ button.
-
Now the screen shows the ‘Ready to Install’. To start installation,, click ‘Install’ button.
-
Now the screen shows some information. Click ‘Next’ button.
-
Now the screen shows the ‘Completing the DbaMgr2k Setup Wizard’. To complete the installation, the system must be restarted. By default, the option ‘Yes. restart the computer now.’ is clicked. Now you just click the ‘Finish’ button to restart the system.
How to work MSDE database with ‘DbaMGR2k’:
-
Click the shortcut ‘DbaMGR2k’ in the desktop.
Or
Click Start->Programs->DbaMGR2k->DbaMGR2k
-
Click ‘Activity’ from the menu-bar and select ‘Edit connection properties/connect’ as shown below:
-
Double-click the text-box next to “User’s password” and enter the user’s password as ‘sa’ (given during installation of MSDE) and click the ‘Connect’ button :
-
If the username & password are correct, then it will show the MSDE database window.
Creation of NREGA & NREGAupload databases:
Now create two databases namely ‘NREGA’ and ‘NREGAupload’.
Now you have to get the Master-tables required for NREGA into NREGA database.
Download NREGA Offline Master Database:
Download the NREGA offline-Master-Tables from http://nrega.nic.in -> Panchayats -> Windows Version -> Select State & enter the password given to your State -> click the link ‘Download Offline Master Database’ and save the zip file in your system. Unzip it. It will extract a MS-access file named ‘nregaOffData.mdb’
In the ‘nregaOffData.mdb’, delete records from the tables States, Districts, Blocks, Panchayats and Villages NOT belonging to your State/District/Block.
If you are using SQL-SERVER 2000/above, then using ‘import’ option you can import all the tables from the ‘nregaOffData.mdb’ into ‘NREGA’ database created in your machine.
OR
If you are using MSDE, then open the extracted ‘nregaOffData.mdb’ by double-clicking it and Export all the tables to NREGA database using ODBC-DSN-Connection. This can be done in the following way:
-
First select a table to export. Select ‘Export’ option in the ‘File’ menu.
-
Dialog box appears. From ‘Save as type’, select ODBC Databases.
-
It will show you the table-name. click OK.
-
A small window titled ‘Select data source’ will appear. Select ‘Machine Data Source’. A list of existing Data-sources appears. If DSN for NREGA is already created, select the DSN (for eg. say ‘dsnNREGA’).
-
If not created already, then create a new DSN by using the following steps:
-
Click ‘New’ button to create a new DSN to export NREGA tables from MS-Access to NREGA MSDE-Database.
-
A window ‘Create New Data Source’ appears. Select the option ‘System data source’ and click ‘Next’ button.
-
Select the driver ‘SQL Server’ displayed in the window & click ‘Next’ button.
-
Click ‘Finish’ button now.
-
In the window titled ‘Create a New Data source to SQL server’, enter the following in the input-boxes displayed:
-
Name : dsnNREGA
-
Description: nrega-sql-dsn
-
Server: select ‘local’ from the list OR enter your machine-name
-
Now select the option ‘with SQL-server ‘Authentication…’
-
Enter valid Login-id & password (say for eg. ‘sa’, ‘sa’ respectively) and click ‘Next’ button.
-
In next window, check (tick) the ‘Change the default database to’ and select ‘NREGA’ from the list and click ‘Next’ button.
-
Click ‘Next’ button in the window displayed.
-
Click ‘Finish’ button.
-
On clicking ‘Finish’, a window titled ‘ODBC Microsoft SQL Server Database’ will appear. Click ‘Test Data source’ to test the data source created.
-
If the ODBC-DSN-connection is successful, it will show ‘TESTS COMPLETED SUCCESSFULLY!’ . click ‘OK’ button now.
-
On clicking ‘OK’ button, you will be directed to ‘Select Datasource’ window. Select the newly created dsnNREGA and click ‘OK’ button.
-
Now it will show a window titled ‘SQL Server login’. Check (Tick) the option ‘Use Trusted Connection’ and Click ‘OK’ button. Now the selected table will be exported to ‘NREGA’ database. You may check it.
-
Now repeat the steps 1,2,3, 4 and 7 until all the tables are exported.
|