MetaFileChoice (Property)

Applies To:

Connection object, MetaDataConnection object

Description:

Returns or sets the value of the MetaData source from the Bqmeta0.ini file. The metadata source is the name of the predefined metadata vendor.

Action:

Read-write, String

Example:

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:

Note:

Do not use MetaFileChoice in Interactive Reporting document files (.bqy).

Example:

This example shows how to set the value of the MetaData source.

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.MetadataUsername"hyperion"
myCon.MetadataPassword = "hyperionhyperion"
myCon.MetaFileChoice = "Broadbase"
myCon.UseAlternateMetadataLocation(true,c:\\OCEs\\PlutoMeta.OCE)
myCon.EnableAsyncProcess = 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")