Oracle SQL Developer version 1.2.1 connection issue

hi,

I am using Oracle SQL Developer version 1.2.1. I want to connect to the Database server using VBScript.
I wrote the below code but getting an Error "database source not found and no default driver specified".

I tried using Driver={Microsoft ODBC for Oracle} but it's saying "No specified Driver"
I don't have authority to download any other driver. Can anybody help me with this?

strCon = "Driver={oracle.jdbc.driver.OracleDriver}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=Basic)" & _
"(HOST=HostName)(PORT=PortNumber))" & _
"(CONNECT_DATA=(SID=prd))); uid=" & UserID1 & "; pwd=" & passwd1 & ";"

0 answers