Connection object, MetaDataConnection object
Enables you not to save the database user name with the Interactive Reporting database connection file (.oce).
This example creates a connection file and applies it to the current document. The data source name 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.SaveWithoutUsername = 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")