Connection object, MetaDataConnection object
Displays the Document Repository Tables in the Table Catalog associated with Interactive Reporting database connection files (.oce).
This example shows how to create an Interactive Reporting database connection file and applies it to the current Interactive Reporting document. The data source name in this example is PlutoSQLSVR, which is a user DSN using the SQL Server 6.5 driver:
Var myCon = Application.CreateConnection()
MyCon.Description = "This OCE configures the connection via ODBC, to a SQLServer 6.5 database named pluto."
myCon.Api = bqApiOpenClient
myCon.Database = bqDatabaseSQLServer
MyCon.HostName ="PlutoSQLSVR"
MyCon.EnableAsyncProcess = true
MyCon.ShowBrioRepositoryTables = true
MyCon.SaveAs("d:\\OCEs\\PlutoSQL.oce")
//Now use this connection in a data model
ActiveDocument.Sections["Query"].DataModel.Connection.Open
("d:\\OCEs\\PlutoSQL.oce")