Oracle error while executing VBscript file - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Oracle error while executing VBscript file

ShrutikhungarShrutikhungar Posts: 2Member
I have a Connection.vbs file with following contents:
************************************************** ****************
Dim strCon

strCon = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST= TRISHUL)(PORT=1525))" & _
"(CONNECT_DATA=(SERVICE_NAME=BTFLVAS))); uid=odb;pwd=odb;"
Dim ocon1:set ocon1=CreateObject("ADODB.Connection")
ocon1.open strCon
************************************************** ****************

Getting this error as a pop up message while executing this file :
Script: D:Connection.vbs
Line: 10
Char: 1
Error: [Oracle][ODBC][Ora]ORA-12560: TNS:protocol adaptor error
Code: 80004005
Source: Microsoft OLE DB Provider for ODBC Drivers

Please help!

Thanks,
Shruti
Sign In or Register to comment.