Connection object, MetaDataConnection object
Enables the log in information specified in the default connection for the metadata connection.
This example creates an OCE 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. SpecificMetadataLogin = 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")