Creating Interactive Reporting Database Connection Files (OCEs)

Example—Create an Interactive Reporting database connection file (OCE)

// try to create sample.oce from scratch.
// create SQLNet-Oracle8 oce - save as sample.oce
MyConnection = ActiveDocument.Sections["Query"].DataModel.Connection
MyConnection.Open("c:\\OCEs\\Sample.oce")
MyConnection.Username = "hyperion"
MyConnection.SetPassword("hyperion")
MyConnection.Connect()
MyConnection.SaveAs("c:\\temp\\sample.oce")


ActiveDocument.Sections["DataModel"].DataModel.Connection.Open("c:\\temp\\astro8.oce")
// need to connect ?
ActiveDocument.Sections["DataModel"].DataModel.Connection.UserName = "hyperion"
ActiveDocument.Sections["DataModel"].DataModel.Connection.SetPassword("hyperion")
ActiveDocument.Sections["DataModel"].DataModel.Connection.Connect()