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!


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}; " & _
"(HOST= TRISHUL)(PORT=1525))" & _
"(CONNECT_DATA=(SERVICE_NAME=BTFLVAS))); uid=odb;pwd=odb;"
Dim ocon1:set ocon1=CreateObject("ADODB.Connection") 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!

Sign In or Register to comment.