0 Shares 1076 Views

Issue with ADODB connection on Window 7 using VBScript – Resolved

Aug 09, 2014
1076 Views

Recent days, I have seen enterprises are migrating their operating systems (OS) from XP to Windows 7 as Microsoft announced the end of support for Windows XP. This resulted in migration of applications,automation scripts and everything else on new OS. In this post we will be discussing about one of the issues which I faced and most of others also had the same situation with their script while migrating to Windows 7 i.e  ADODB connection on Window 7 using VBScript. 

ADODB connection is used in VBScript to connect to the Database(Oracle/Sybase/DB2/SQL Server/Excel) and fetch the required data from databases .We have one of such VB script file which fetches the values from Database using ADODB object.The vbs file was getting executed without any error on Windows XP. But when we tried to execute it on Windows 7  ,we received the below error :

The reason for the above error is related to the way the VB Script communicates with the Operating System. Windows 7 is of  64 bits while the ADODB driver is available only in 32 bits.When the VBScript file is invoked on 64 bits OS ,by default it will be invoked by 64 bit Wscript/CScript interpreter which lead to ADODB error.

To resolve ADODB connection issue ,follow the below steps:

Instead of opening command line everytime,batch file can be created by following the below steps:

 Note : You don’t need to use the 32 bit WScript/CScript interpreter everytime while using the vbs file.It is only needed when you are doing connections to Database/Quality Centre/ALM.

Hope this article helps you in your smooth migration of your automation script from Windows XP to Windows 7 by resoling ADODB connection issues.If you face any issues related to the migration of automation scripts feel free to contact us.

Till then

Happy learning!!!!

 

You may be interested

Setting up Web Service Automation Project
Katalon Studio
240 views
Katalon Studio
240 views

Setting up Web Service Automation Project

Saket - Oct 24, 2017

Web services are specific services that can be published and called over the Internet by client applications. Katalon Studio supports functional testing of web services. This topic…

Setting up Mobile Automation Project in MacOS
Katalon Studio
241 views1
Katalon Studio
241 views1

Setting up Mobile Automation Project in MacOS

Saket - Oct 09, 2017

Using Katalon Studio, mobile tester can design automation test for both Android and iOS to run on physical devices, cloud services and emulators. This tutorial explains how…

UFT Jenkins Integration
Unified Functional Testing
795 views
Unified Functional Testing
795 views

UFT Jenkins Integration

Saket - Oct 03, 2017

In our earlier post, we got to know the easy integration of UFT with GIT. This post focuses on integration of UFT and Jenkins. I have also…

Leave a Comment

Your email address will not be published.

Most from this category

Join The Growing Group of 15000+ Test Automation Engineers

Signup for our newsletter and get access to free downloads, as well as tips, tricks and techniques and various test automation resources.
Name
Email Address
Secure and Spam free...