Connection object, MetaDataConnection object
DB-Lib Only. The DBLibUseSQLTable (Property) enables the connection to use Structured Query Language (SQL) to get tables.
Do not use DBLibUseSQLTable inInteractive Reporting documents to be deployed in the EPM Workspace. |
This example shows how to create a connection (OCE) that uses SQL to get tables:
var myCon myCon = Application.CreateConnection() myCon.Api = bqApiOpenClient myCon.Database = bqDatabaseSQLServer MyCon.HostName ="PlutoSQLSVR" MyCon.DBLibUseSQLTable = 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")