connectSpec( “[host]” “[sid]” “[port]” “[user]” “[password]” )


Initiates a connection to an Oracle OLAP instance.  Unlike connect a valid XML connection file is not required.  However the developer must provide the necessary connection information during the function call.


Syntax


               connectspec("[host]" "[sid]" "[port]" "[user]" "[password]")



Return Value


               BOOLEAN


Example


Public Sub connectSpec()

'Create a manual connection without a connection xml file


Dim hostname  As String

Dim sid As String

Dim port As String

Dim username As String

Dim password As String


If Not oregistered Then:   boo = regQ:

 

hostname = "yourHostName"

sid = "yourSid-orcl"

port = "yourPort-1521?"

username = "yourUserName"

password = "yourUserPassword"


boo = o.connectSpec(hostname, sid, port, username, password)


If boo = True Then

 MsgBox "Connected OK"

Else

 MsgBox "Not Connected"

End If


End Sub