Skip to main content

Posts

How to Import Data (tables) from Postgresql to MS Access Database using ODBC : Step by Step Tutorial

 Import Data (tables) from Postgresql to MS Access Database using ODBC : Step by Step Tutorial for data migration from one Database System to Another Database System. Objective :- Transfer data tables form PostgresSQL database to MS Access Database. Step1:- Create a Blank MS Access Database in your Windows system. Step2:- Open that newly created Access database and go  the External Data tab. Next Click on the More button. Where you will find lots of options. Select the ODBC_databse form that list.   Step 2: Select the source and destination of data. Select the option "Import the Source Data into a new table in the current database", and click OK. Step3: A new Popup window will appear on the screen. Click on the "Machine Data Source" tab. Here you will see the all DNS , data source names . We will select for example "BE" data source name and click OK. Step 4: Import Objects. In this step you will find all the tables under the BE database. Click on the SELEC...

Working Principles of the Layer 2 switch & Layer 3 switch | Network Administration

 Working Principles of the Layer 2 switch & Layer 3 manage switch  | Network Administration. Switches are Layer 2 device, Routers are Layer 3 device The new generation of Layer 3 switches route using hardware only. A switch will examine the incoming frame's MAC header to determine the physical address of the destination device. Whereas a HUB , simply repeats an incoming frame out of all its ports, the switch creates a virtual path to forward frames to the port. Where it knows the destination device exist. Switch can provide flow control to network traffic by temporarily storing frames in a buffer.  Switch can also generate BACK PRESSURE to cause transmitting device to wait long enough for the switch to deal with backlogged traffic. To create back pressure, the switch broadcast false collation detection signals to cause network interface card to back off.  

Orange { HRM } Human Resource Management Open Source Software installation Process

 Orange HRM Software Installation Process in Your Local Windows PC Step 1: Download the OrangeHRM for Windows. Step 2: Install xampp server for windows. {apache, mysql} Step 3: Now unzip the downloaded software. A. You will find orangehrm x.x folder. B. Copy this folder to the C:\xampp\htdocs C. In your browser, type localhost/orangehrm-x.x D. A configuration web based window will appear. Step 4: Database configuration Database to Use       | New Database| Database host name |localhost         | Database host port   | 3306             | Database Name        | orangehrm_mysql | Privileged DB user Name  | root      | Privileged DB password    | root123 | Use the same DB user for Orange HRM .Yes OrangeHRM DB username |orangehrm| OrangeHRM DB userpassword |orange 123| E...

How to install Eclips PHP IDE software in Windows System for Software Development

 Q. How to install Eclips PHP software in Windows System ? Ans:  Step 1: Download the Eclips PHP. (www.eclips.org) Step 2: Unzipe the folder and copy the folder to the appropriate drive. Step 3: Rename of eclips-php. Step 4: Make a short cut to Desktop. Step 5: Click on the setup icon and it will automatically installed the software for you. Step 6: Next, when you first Run the eclips, then it will ask you to give the work space path. Step 7: That Path should be "xampp / htdoc " folder. Otherwise it will not display in browser. Note: Before install PHP, Download the xampp software  and install it in your Windows System. NB:- An integrated development environment (IDE) is software for building applications that combines common developer tools into a single graphical user interface (GUI).    

How to create user DSN with ODBC driver in Windows System for PostgresSQL Database

 How to create user DSN with ODBC driver in Windows System : Step by Step Tutorial Guide : Step 1: Go to Windows start button -->Click Settings --->Click on Control Panel Step 2: In control panel go to the Administrative Tools Step 3: Double Click on the Data Source(ODBC) icon. A small popup screen with lots of tabs will be appear on the screen. Step 4: Click on the User DSN tab. Step 5: Now click on the ADD button. Now you can see lots of ODBC drivers in the List. Select the appropriate Driver form the List, for example here we chose the PostgresSQL ODBC driver. Step 6: Click on the Finish button. Step 7: Now give the data source name in the appropriate box. Similarly give the database name, ip address of the database server (may be localhost or other private IP address ),then Give the User Name and Password of the database in the appropriate box. Step 8: Press the TEST button to check the connection, whether you put all the parameters correctly or not. If everything is OK t...

How to Upload a New Module in Drupal Content Management System ?

 Q. How to Upload a New Module in Drupal Content Management System ? Ans: Go to the Module tab and check the Update Manager and save it. Otherwise you can't upload new modules in drupal CMS.   

How to configure the MRTG to Poll multiple devices in Linux Operating System ?

  Getting MRTG (Multi Router Traffic Grapher) to Poll multiple network devices. The Fedora Core MRTG installation process create a CORN file named /etc/corn.d/mrtg . This file tells the corn daemon to run MRTG using /etc/mrtg/mrtg.cfg file every 5 minutes to poll your network devices. You can configure MRTG to poll multiple devices, each with a separate configuration file. 1. Create a new configuration file using the steps from the previous section, choose a file name that is not mrtg.cfg 2. Add a new MRTG lene in / etc/corn.d/mrtg for each new configuration file you create. 0-59/5 **** root env LANG=C /usr/bin/mrtg  /etc/mrtg/mrtg.cfg 0-59/5 **** root env LANG=C /usr/bin/mrtg /etc/mrtg/dervice1.cfg 0-59/5 **** root env LANG=C /usr/bin/mrtg /etc/mrtg/device2.cfg 3.Run the indexmaker command, and include all of your /etc/mrtg configuration files. 4. Other versions of Linux keep their MRTG corn entries inside /etc/corntab file. Edit this file using the same syntex. Now , re...