0 Shares 2091 Views

Issue with ADODB connection on Window 7 using VBScript – Resolved

Aug 09, 2014
2091 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

UFT Patch Updates – UFT 14.03
Unified Functional Testing
434 views1
Unified Functional Testing
434 views1

UFT Patch Updates – UFT 14.03

Saket - Mar 11, 2018

Post the launch of UFT 14.0, there are three patch updates has been released including a number of features and enhancement. Recently Micro Focus unveiled third patch…

Setting up Web Service Automation Project
Katalon Studio
876 views
Katalon Studio
876 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
820 views1
Katalon Studio
820 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…

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...