CODEWITHSUNDEEP
sqloracle-databasevbscript
Priyanka Kaushik
Priyanka Kaushik

Reputation: 153

VBSCRIPT connection to Oracle failing due to driver

I am using a vbscript which connects to SQL. My connection String look like 

connectionString = "DRIVER={Microsoft ODBC for Oracle};SERVER=convcsd;User Id=sysman;Password=csaadmin;"
    Set connection = CreateObject("ADODB.Connection")

It is working on one server but not on another. it gives an error :

The oracle(tm) and networking components were not found. These components are supplied by oracle corporation..

You will be unable to use this driver until these components have been installed.

Please let me know how to add ODBC driver. I researched but not able to get through.

Upvotes: 4

Views: 6473

Answers (1)

peter
peter

Reputation: 42182

SQL Plus is an Oracle client yes but that is not enough to be able to use your script. You need an ODBC driver and prefable an OleDb driver (is faster) for Oracle on each pc you're going to use your script.

Compare the ODBC drivers between two 2 pc's with the Microsoft ODBC administrator (type ODBC in your startmenu searchwindow) and you will notice the difference. Use your Oracle installpackage and check the option to install the OleDb driver.

There is a Microsoft and an Oracle version, again it is best to use the Oracle driver. The connection string for Oracle OleDb is 

Provider=OraOLEDB.Oracle;User ID=<user name>;Password=<password>;Data Source=<data source>

Upvotes: 4

Related Questions