How to connect Oracle using QTP scripts

How to connect Oracle using QTP scripts.

Dim connectionMS, recordsetMS
Set connectionMS = createobject(“adodb.connection”)
Set recordsetMS =createobject(“adodb.recordset”)
connectionMS.open “Driver={Microsoft ODBC for Oracle};Server=QTPWorld; Uid=your_username;Pwd=your_password;”
recordsetMS.open “select * from yourtablename”,connectionMS
databaseValue = recordsetMS.fields.item(0)
msgbox databaseValue
Set connectionMS = nothing
Set recordsetMS = nothing

How to connect sqlserver using QTP scripts

How to connect sqlserver using QTP scripts?

Dim connectionMS, recordsetMS

Set connectionMS = createobject(“adodb.connection”)
Set recordsetMS =createobject(“adodb.recordset”)

connectionMS.open”Driver={SQL Server};server=YourSqlServer;uid=YourUserName;pwd=YourPassword;database=dbname”
recordsetMS.open “select * from tablename”,connectionMS
databaseValue = recordsetMS.fields.item(0)
msgbox databaseValue
Set connectionMS = nothing
Set recordsetMS = nothing

How to connect MS Access using QTP scripts

How to connect MS Access using QTP scripts and display results

Dim connectionMS, recordsetMS

Set connectionMS = createobject(“adodb.connection”)
Set recordsetMS =createobject(“adodb.recordset”)

connectionMS.provider= “microsoft.jet.oledb.4.0”

connectionMS.open “C:\yourdatabase.mdb”
recordsetMS.open “select * from YourtableName”,connectionMS

databaseValue = recordsetMS.fields.item(0)
msgbox databaseValue

Set connectionMS = nothing
Set recordsetMS = nothing

Jmeter Installation steps

Dear visitors .. please go through the link and support fundraising for Team Tara Pai

Jmeter Installation steps

  1. Download JMeter from (http://jmeter.apache.org/download_jmeter.cgi ) è by clicking the on the “apache-jmeter-2.13_src.zip md5 pgp” link (Binaries or Source)
  2. Extract the contents to a folder from ZIP file.
  3. Open the DOS command prompt (Flow: click on Start menu, Type cmd).
  4. In DOS screen – Navigate to the <JmeterHome>\bin directory.

install-4

  1. Type Jmeter.bat in the above mentioned command prompt.  That will bring the Jmeter application ready for performance testing.

install-5

  1. Or click on Jmeter.bat file listed in <JmeterHome>\bin should bring the application.

install-6

Trending as of Jan 11 2017

Trending as of Jan 11 2017 – My most favorite hobby is market research based on what i read from various news media. I focus mainly on new brands of cars, mobile phones, Laptops, software, new deals on various sites etc.. However this information may not be accurate and this is just my views and what I understood. Others would have their on views..:-)

Date: Jan 11-2017

  1. H1 and L1 Visa news about hiking the minimum wages to $100k is trending news in Indian medias on this week. This news is causing lots concerns on Indian IT professionals living in USA about their Job security as well as IT companies concerns about their margins. Some of the IT majors are already started to make changes to their business model to handle this issues proactovely.

expecting more updates..

2. WhatsApp beta v2.17.6 will be supporting GIF search. this is something i was eagerly looking for. GIF images are light weight files and easy to share and express any flow and is a nice replacement for video clips..:-)

 

Date: Jan 10-2017.

1. 2018 Odyssey minivan’s modern look is amazing and this fifth generation model would definitely hit market with good responses.. Some of the features I likes are..new safety features, design changes, interior seat flexibilty for second row seats,  better technology to avoid collision, cabin control, more power etc

2. Xiaomi Redmi Note 5

Xiaomi expected to release its Note 5 version in 2017 .. Expected to have resolution 1920×1080 pixels with 2.5d curved IPS and 5.5 inch size..

Rear camera expected to have 16MP with PDAF

Expected processor Snapdragon 652 it’s core

Top car companies and their brands

Top car companies and their brands. Some of the top car companies are GM, HYUNDAI, VOLKSWAGEN, GEELY, BMW, PSA,HONDA, NISSAN, FCA, DAIMLER, FORD, TOYOTA, TATA and  RENAULT

Top car brands are,

GM – CHEVROLET, OPEL, HOLDEN, CADILLAC, VAUXHALL, GMC, WULING MOTORS, BAOJUN, BUICK

HYUNDAI – KIA, HYUNDAI

VOLKSWAGEN – AUDI, SKODA, BENTLEY, VOLKSWAGEN, BUGATTI, LAMBORGHINI , PORSCHE

GEELY – GEELY, VOLVO,

BMW – BMW, MINI, ROLLS-ROYCE

PSA -CITROENA,

HONDA – HONDA, ACURA

NISSAN -NISSAN, DATSUN, INFINITI

FCA – FIAT, CHRYSLER,

DAIMLER – BENZ, SMART

FORD – FORD

TOYOTA – TOYOTA, LEXUS, DAIHATSU

TATA – TATA MOTORS, LAND ROVER, JAGUAR

RENAULT – DACIA, RENAULT, SAMSUNG

 

 

My favorite

My favorite …This blog is about my favorite ..

Songs – Side to Side of Ariana grande, Anaconda of Nicki Minaj, Never let you go , Sorry of Justin Bieber.

Singers – Justin Bieber , Taylor swift, Ariana grande,  Vidya Iyer, Lady Gaga & Nicki Minaj

Actress and models – Lisa Haydon, Sonam Kapoor

Actors – Salman Khan, Amir Khan, Shah Rukh Khan

Companies – Amazon, Flipkart, Uber, Google

Movies – Dangal, Sultan

Mobile Phones – Apple iPhone 7 and HTC 10.

Cars –  Tesla Model S, X, 2017 Mercedes-Benz CLA-Class, BMW 5 series, 

SUVs – Mercedes-Benz GLS-class, BMW X6,

Minivan – 2018 Honda  Odyssey, Sienna 2017

Mobile internet connection – Reliance Jio 4G

 

Trending news as of Jan 10 2017

Trending news as of Jan 10 2017 – My most favorite hobby is market research based on what i read from various news media. I focus mainly on new brands of cars, mobile phones, Laptops, software, new deals on various sites etc.. However this information may not be accurate and this is just my views and what I understood. Others would have their on views..:-)

Date: Jan 10-2017.

1. 2018 Odyssey minivan’s modern look is amazing and this fifth generation model would definitely hit market with good responses.. Some of the features I likes are..new safety features, design changes, interior seat flexibilty for second row seats,  better technology to avoid collision, cabin control, more power etc

2. Xiaomi Redmi Note 5

Xiaomi expected to release its Note 5 version in 2017 .. Expected to have resolution 1920×1080 pixels with 2.5d curved IPS and 5.5 inch size..

Rear camera expected to have 16MP with PDAF

Expected processor Snapdragon 652 it’s core

 

 

Sunset from Manhattan New York

Sunset from Manhattan New York. Sunrise and sunset are the beautiful time in a day from anywhere in the world.

Enjoy the Sunset near Central park, New York. Manhattan is one of the must see places in USA.

 

My google adsense story

My google adsense story 🙂

Google Adsense has been around more than 10 years from now. But I did not pay attention much until I read an article that said “top earners of Adsense ” which is monthly ‘makings’ is more than a $100k..

How did I start? About my background?

At that point of time, I was not aware of WordPress or domain services or even the difference between webhosting vs domain services. The main reason was my career was teaching and little bit of freelancing experience on digital marketing and functional testing.

YouTube is my teacher who upgraded me as a so called techie guy …I easily started WordPress development but the challenge was hosting the content from WordPress.

My failed attempts on web hosting and google Adsense approvals…  By that time I got a deal from godaddy and registered my domain. But hosting from WordPress was still challenging me.

My inability to successfully host WordPress site paid me off ! HTML 5, CSS, Node.JS, Java scripts …all technical stuffs got added to my skill set and I started Github hosting, My godaddy is linked to Github and finally my site www.shalimatech.com was live on around Oct 2016.

I started dreaming about the precious article I read “top earners of Adsense “. That dream had only 2 days life as I got email from google Adsense that my first request on Adsense program was rejected  saying “not enough content”

Okay, let me add more contents..btw site quality was poor like responsiveness, mobile and most modern browser support, along with contents which I wasn’t aware or did not pay attention to that as my primary focus was to make money   ..greedy me right. YouTube did not help me much on this ..I added 5 more cooking recipes and 10 more technical blogs on my site. Submitted with much more confidence. This time I did not have to wait much..google immediately informed me about their decision of rejection on my hard work.

My 3rd attempt. This time again google advised – Improve contents! I decided to fill contents ..added 50 cooking recipes and 20 technical blogs .. My confidence level was so high, I ignored about other technicalities that google looked for. Resulting 3rd rejection 

Bye to Bye to Github ..that is the first thing I did on the day I received rejection email from google.

Coming back to WordPress ! ..this time YouTube came to rescue..got a nice video on how to develop and host a website. I looked again for deals…this time web hosting deals. Found one hostgator offered 1 cent for 1st month.

Finally godaddy hostgator WordPress tie up went live on 2016 Christmas holidays season. .. I moved all Github contents that I had to My site www.shalimatech.com.  the site got new design, all new modern features..cudos to wordpress.com and wordpress.org.

Now google Adsense approval..this is going to be my 4th attempt..by this time my site was getting good views and user coverage mostly Europe and south American viewers..I need to analyze why Europe and South America ..why not others….May be my next research topic and subsequent blog!

I was confident and submitted My request for adsense approval..I did it this time ! Got email within 3hours from google adsense approving my site.

I was at New year party at friend’s time..welcoming 2017…it doubled my happiness. But I realized google still fully ready to give me the job!

I learned that google has 2 stages of approval and this was first stage. I again opened YouTube and other blog sites..while waiting for approval ..I continued adding blogs and I hit 60 technical blogs milestone..

I got Google’s blessing on Jan 6th  2017- my site is adsense ready and I started thinking about my precious blog  “top earners of adsense ” I read. And dream started again..

My First day earning .. I setup ad codes on 6th evening and to my surprise Jan 7th reports showed My first day earning $ 1.82!!! I was so happy and started sharing my success story to my friends..

Today is my second day…… I am frequently logging to my adsense account and checking reports as well as WordPress dashboard and  view statistics…

I hope my story will certainly inspire you ..this journey made a decent programmer and a “techie” …

I am going to post a blog on tips and tricks on how to get easily google approval ..WordPress site development tips and tips for domain registration and hosting soon.. Good luck…