|
I am trying to run a oracle query using a vbs file.
Server Details: Windows Server 2003 Enterprise x64 edition and has Orcale 10g Client installed (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0).
In the vbs file I have write the below lines to connect to database,
***
Dim objConnection, objRecordset
Set objConnection = CreateObject("ADODB.Connection")
strConnString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=S ERVERNAME)(PORT=1521))(CONNECT
_DATA=(SERVICE_NAME=TEST)));uid=username;pwd=passw ord;"
objConnection.open strConnString
Set objRecordset = CreateObject("ADODB.Recordset")
Set objRecordset = objConnection.Execute ("SELECT enabled_ind FROM DB_RELEASE")
objConnection.Close
Set objRecordset = Nothing
Set objConnection = Nothing
***
When I run the vbs file it gives me error, "Provider is not specified and there is no designated default provider".
Server doesnt have any ODBC drivers except for 'Oracle in Orahome10g'.
What I am doing wrong, please help.
Thanks,
Hari
| 
