Connection object, MetaDataConnection object
ODBC Only. The ODBCEnableLargeBufferMode (Property) enables ODBC connections to use a larger buffer mode.
This examples shows how to create an Interactive Reporting database connection file and applies it to the current document. The data source name in this example 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.ODBCEnableLargeBufferMode = 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")