Not able to connect to Oracle SQL Developer

[Paras Singh]

Hi,

Not able to connect to Oracle SQL Developer, pls help asap.
Oracle SQL Developer Version : 3.0.02

I am using the below codes:
1) Using Microsoft ODBC for Oracle

Code:

Dim StrDBDesc,strUserID,strPassword,ADOBDConnection

StrDBDesc = "(description=(address=(host=hostname)(protocol=protocol name)(port=portnumber))(connect_data=(service_name=service name)))"
strUserID = "username"
strPassword = "password"

Set ADOBDConnection = Createobject("ADODB.Connection")
strConnection = "Driver={Microsoft ODBC for Oracle};CONNECTSTRING=" &StrDBDesc&";Uid=" &strUserID& ";Pwd=" &strPassword&";"
ADOBDConnection.Open strConnection

2) Using Provider=OraOLEDB.Oracle

Code:

Dim StrDBDesc,strUserID,strPassword,ADOBDConnection

StrDBDesc = "(description=(address=(host=hostname)(protocol=protocol name)(port=portnumber))(connect_data=(service_name=service name)))"
strUserID = "username"
strPassword = "password"

Set ADOBDConnection = Createobject("ADODB.Connection")
strConnection = "Provider=OraOLEDB.Oracle;Data Source="&StrDBDesc&";UserID="&strUserID&";Password="&strPassword&";"ADOBDConnection.Open strConnection

By using above two ways of codes, I am getting the errors, attached the doc.


PLease Help on this..
Thanks,