Connection object, MetaDataConnection object
DB-Lib only. The DBLibDatabaseCancel (Property) enables you to change the Database cancel options.
Do not use DBLibApiDatabaseCancel in Interactive Reporting documents to be deployed in the EPM Workspace. |
The BqDbLibCancelMode constant group consists of these values:
This example shows how to create a connection (OCE) using JavaScript:
var myCon
myCon = Application.CreateConnection()
myCon.Api = bqApiOpenClient
myCon.Database = bqDatabaseSQLServer
myCon.HostName ="PlutoSQLSVR"
myCon.DBLibDatabaseCancel = bqDbLibPrompt
myCon.SaveAs("d:\\OCEs\\PlutoSQL.oce")
//Now use this connection in a data model
ActiveDocument.Sections[“Query”].DataModel.Connection.Open
(“d:\\OCEs\\PlutoSQL.oce”)