Error:
D:\PRTG Network Monitor\custom sensors\EXE\oraclevb3.vbs(14, 1) OraOLEDB: ORA-12154: TNS:could not resolve the connect identifier specified
Script:
Dim strSQL
Dim strUsername
Dim strPassword
Dim snpData
Dim dbMyDBConnection
Set snpData = CreateObject("ADODB.Recordset")
Set dbMyDBConnection = CreateObject("ADODB.Connection")
strUsername = "user"
strPassword = "pass"
dbMyDBConnection.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=MyDB;User ID=" & strUsername & ";Password=" & strPassword & ";"
dbMyDBConnection.Open
strSQL = "select count(*) from requests"
snpData.Open strSQL, dbMyDBConnection
While Not snpData.EOF
WSCript.Echo snpData.Fields(0).Value & ":ok"
snpData.MoveNext
Wend
snpData.Close
dbMyDBConnection.Close
Set snpData = Nothing
Set dbMyDBConnection = Nothing
Others:
1. The server has oracle client installed with tnsnames configured to MyDB.
2. Running the script on command line works ok.
EDIT by Paessler: Adjusted formatting.
Custom scripts are not supported by the support team here at Paessler. Hopefully someone else in the community will be able to assist you.
Sep, 2014 - Permalink