Filename (Property)

Applies To:

Connection object, MetaDataConnection object

Description:

Returns the full name and path of the Interactive Reporting database connection file (.oce) associated with the connection object.

Action:

Read-only, String

Example:

This example creates an Interactive Reportingdatabase connection file and associates it with the current Interactive Reporting document:

var myCon = Application.CreateConnection()
myCon.Description = "This OCE configures the connection via ODBC, to a SQLServer 6.5 database named pluto.".Api = bqApiOpenClient
myCon.Database = bqDatabaseSQLServer
myCon.HostName ="PlutoSQLSVR"
myCon.SaveAs("d:\\OCEs\\PlutoSQL.oce")

//Now use this connection in a data model
ActiveDocument.Sections["Query"].DataModel.Connection.Open
("d:\\OCEs\\PlutoSQL.oce")
var OCEFilename = ActiveDocument.Sections["Query"].DataModel.Connection.Filename
Console.Write ("Successfully opened the OCE named: "+OCEFilename)