It took me 5 days to get this correctly working and although there is information available on internet, its all scattered and leads to multiple directions, which can be very time consuming and frustrating. Hope below answer will give you a step by step answer with references, and code examnples to try out your code and get this up and running for you. (when running a working script on 64-bit terminal) The 'OraOLEDB.Oracle.1' provider is not registered on the local machine (when tried using oraOLEDB driver). It may not be properly installed (when using Microsoft ODBC for Oracle) When any one of the above is wrong, we get a range of errors depending on which driver, connection string and terminal we are using. Using the wrong terminal to test the code (i.e.The main reason I found this for going wrong is a wrong combination of one or more of below: I spent close to 6 days to get this working and thus I feel its worth to share all the detailed steps here. In most places, there are answers in bits and pieces, without any one detailed answer that helps user get this information. It seems the question on how to connect to oracle database from UFT/VBscript is asked on multiple forums.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |