Connection to Oracle database

[khshankar]

I am trying to run a oracle query using 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 wrote 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'.

This server is 64 bit, but the same coding works when I run it from a 32 bit server.

What I am doing wrong, please help.

Thanks,
Hari

 

[PHV]

Have a look here:

http://www.connectionstrings.com/?carrier=oracle

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[khshankar]

Thanks for the link, I tried all the options. It works from a 32bit server but not in 64bit server.

Thanks,
Hari