Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Try to connect oracle server through UFT.Getting Ora6413 error
#1
Not Solved
Try to connect oracle server through UFT.Getting Ora6413 error

Code:
Function DBExecuteField(ByVal DB_NAME,ByVal DB_HOSTNAME,ByVal DB_PORTNUM,ByVal DB_USR,ByVal DB_PWD)
                
                On error resume next
                                
                Set objConnection = CreateObject("ADODB.Connection")
        Set objRCset=CreateObject("ADODB.RecordSet")
            
                ConStr = "Driver={Microsoft ODBC for Oracle}; " & _
                "CONNECTSTRING=(DESCRIPTION=" & _
                "(ADDRESS=(PROTOCOL=TCP)" & _
                "(HOST=" & DB_HOSTNAME & ")(PORT=" & DB_PORTNUM & "))" & _
                "(CONNECT_DATA=(SID=" & DB_NAME & "))); uid=" & DB_USR & ";pwd=" & DB_PWD &";"
                                
                objConnection.Open ConStr
                objConnection.CommandTimeout = 300
                End Function
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Need script to connect remote machine stalinvanama 1 1,448 09-27-2018, 08:12 PM
Last Post: stalinvanama
  Request Help | Usage of Oracle Add-In for Oracle SQL Developer Nasir Ahmed 3 3,295 06-18-2014, 04:28 PM
Last Post: vinod123
  Connect QTP 10.0 with Unix phabloxar 1 3,205 09-20-2012, 09:32 PM
Last Post: phabloxar
  How to connect to SYBASE DB, please help. martinlam 0 4,992 09-20-2010, 02:08 PM
Last Post: martinlam
  How to connect to Linux m/c from QTP script for validatating the new created dir rao 1 3,029 07-23-2009, 12:51 PM
Last Post: QTPian

Forum Jump:


Users browsing this thread: 1 Guest(s)