Oracle Connection String

[kalaigan]

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("A DODB.Connection ")

strConnString = "Data Source=(DESCRIP TION=(ADDRESS=( PROTOCOL=TCP)(H OST=SERVERNAME) (PORT=1521))(CO NNECT
_DATA=(SERVICE_ NAME=TEST)));ui d=username;pwd= password;"

objConnection.o pen strConnString

Set objRecordset = CreateObject("A DODB.Recordset" )

Set objRecordset = objConnection.E xecute ("SELECT enabled_ind FROM DB_RELEASE")

objConnection.C lose
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

[Dave44]

I think you need to post this over in a vbs forum. It doesnt seem that your getting your connection to the database set up properly.