ADODB.Connection: Operation is not allowed when the object is closed

HCL Domino Domino Forum
1

I am trying to connect with oracle10g database using ADODB but its not connecting. code snippets is :

oConn As Variant

oCmd As Variant

oRs As Variant

Set oConn = CreateObject(“ADODB.Connection”)

Set oCmd=CreateObject(“ADODB.Command”)

Set oRs=CreateObject(“ADODB.Recordset”)

	oConn.Open |Provider=OraOLEDB.Oracle;

					Password=|& Password&|;

					User ID=|& Username&|;

					Data Source=|& Data source&|;

					Persist Security Info=True|