Geek asks and answers

VBSCRIPT connection with Oracle does not work due to driver

I am using vbscript which connects to SQL. My connection string looks like

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

It runs on one server, but not on another. he gives an error:

Oracle (tm) and network components not found. These components are supplied by oracle.

You cannot use this driver until these components are installed.

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

+3
source share
1 answer

SQL Plus is an Oracle client, but this is not enough to use a script. You need the ODBC driver and the prefable OleDb driver (faster) for Oracle on every PC that you are going to use the script.

ODBC Microsoft ODBC ( ODBC startmenu), . Oracle OleDb.

Microsoft Oracle, Oracle. Oracle OleDb -

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

More articles:


All Articles