Connecting DB2 in AIX server

HCL Domino Domino Forum
1

we have wrote below script to connect DB2, it works fine in the client side but it does not run in the AIX server when sheduled.can i know what else i should do.

Dim conn As Variant

Dim sCN As String

Dim strSQ,strSQL1,strSQL2 As Variant	

Set conn = createobject("ADODB.Connection")

conn.ConnectionTimeout = 30

conn.Provider = "IBMDA400"

conn.Properties("Data Source") = "192.168.22.254"

	conn.Properties("User ID") = "abc"

	conn.Properties("Password") = "abc"

conn.Open



If Conn Is Nothing Then

MessageBox("Cound not connect to Server")

	Exit Sub

End If

thanks in advance

Niluki

2

Subject: Connecting DB2 in AIX server

CreateObject is OLE Automation. OLE Automation does not exist on AIX.

From CreatObject help in Domino Designer.

Creates an OLE Automation object of the specified class.

Note CreateObject is not supported under OS/2 or UNIX. It is supported on the Macintosh as long as OLE support is installed.

Take a look at the LSX for Lotus Connectors in Domino Designer Help

3

Subject: RE: Connecting DB2 in AIX server

Dear Carl

Thanks for your reply now I wrote like this

Option Public

UseLSX “*LSXLC”

Sub Initialize

Dim session As New LCSession         

Dim conn As New LCConnection("db2") 



conn.database = "MTVD"  

conn.userid = "abc"

conn.password = "abc"

conn.procedure = "DB2ADMIN.NOUI"    

conn.Connect

End sub

its still not wrking.“conn.database” how do u get the correct name and for conn.procedure- which user we shd write please expllain. is there any thing to set in the server if so what are they.

thanks

niluki

4

Subject: RE: Connecting DB2 in AIX server

please let me know what to set on the server (AIX) to make this wrk.couse the shdule agents runs fine it does not wrk when the connection is applied.(LSXLC).