Connection object, MetaDataConnection object
DB-Lib Only. The DBLibUseQuotedIdentifiers (Property) enables you to use of quoted indentures when connecting by using DB-Lib.
Do not use DBLibUseQuotedIdentifiers in Interactive Reporting documents to be deployed in the EPM Workspace. |
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.DBLibUseQuotedIdentifiers = 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”)