Posts

Showing posts from June, 2011

Query from text file and retrieve records using ADODB

Query from text file and retrieve records For example we have the following text file “Employees.txt” LastName,FirstName,Department,Role Nandvani,Rajiv,IT,Manager Kumar,PP,Finance,Analyst Shukla,Nikhil,R&D,Programmer Singh,ANIL,QA,Tester ARORA,ANUJ,QA,Team Leader Kumar,Neeraj,IS,Manager Is it important that your text files be formatted like this? It’s not just important, it’s crucial. We’re going to use database techniques to retrieve information from the file, and to do that the file needs to be delimited in some way (in this case, using the comma as the delimiter).

QTP Mercury DeviceReplay vs SendKeys/ Right click mouse

The Device Replay feature is used to perform mouse and keyboard actions against screen coordinates that are provided. The Device Replay functions are not automatically recorded, but must be programmed manually in the Expert View. 1. Create the Device Replay Object. Example: Set DeviceReplay = CreateObject(“Mercury.DeviceReplay”) 2. Call the desired Device Replay function. Example: DeviceReplay.SendString(“Hello, World”) 3. When done with the Device Replay object, release it. Example: Set DeviceReplay = Nothing The functions that can be used with the Device Replay object are (all coodinates are relative to the top left corner of the screen):

JMETER run in GUI mode from putty on remote Linux machine.

Image
Jmeter run in GUI mode from putty on remote Linux machine.   Please do the following steps to see the Jmeter window. 1. Install Xming ( http://www.straightrunning.com/XmingNotes/ ) on windows.      Download Source (install with portable putty enabled option.)       http://sourceforge.net/projects/xming/ 2. Enable the X11 forwarding in putty.     3. Xming installation directory there is a host file C:\Program Files\Xming\X0.hosts Edit: X0.hosts (lay in the installation directory) add the ip you want to allow. my X0.hosts “localhost 10.6.9.21″ Here 10.6.9.21 is the ip address of Linux machine.       4. Start your SSH session 5. On your ssh remote session, put this : DISPLAY=YOUR_IP_WINDOWS:0.0 export DISPLAY (Replace YOUR_IP by the IP of your windows) Verify display is set or not Type echo $DISPLAY Still if you are not able to set Display variable value Then update in pr...

Web Terminologies Part 2

• SSL (Secure Sockets Layer) – Protocol for establishing a secure connection for transmission, it uses the HTTPS convention – SSL provides endpoint authentication and communications privacy over the Internet using cryptography. In typical use, only the server is authenticated (i.e. its identity is ensured) while the client remains unauthenticated; mutual authentication requires public key infrastructure (PKI) deployment to clients. The protocols allow client/server applications to communicate in a way designed to prevent eavesdropping, tampering, and message forgery. – SSL involves a number of basic phases: o Peer negotiation for algorithm support o Public key encryption-based key exchange and certificate-based authentication o Symmetric cipher-based traffic encryption o During the first phase, the client and server negotiate which cryptographic algorithms will be used. Current implementations support the following choices: o for public-key cryptography: RSA, Diffie-Hellman, DSA or ...