Database (Property)

Applies To:

Connection object, MetaDataConnection object

Description:

Returns or sets the name of the database vendor and version number.

Action:

Read-write

Constants:

These values consists of BqDataBase constant group:

bqDatabaseAS400
bqDatabaseDB2
bqDatabaseDB2Olap
bqDatabaseEssbase
bqDatabaseInformix7
bqDatabaseMicrosoftSQLServer7
bqDatabasenone
bqDatabaseODBC
bqDatabaseOLEDB
bqDatabaseOracle8
bqDatabaseRedBrick5Warehouse
bqDatabaseSybaseSystem
bqDatabaseTeraData

For all values, see the Interactive Reporting Object Model Script Editor.

Example:

This example shows how to create a connection (OCE) using JavaScript:

var myCon
myCon = Application.CreateConnection()
myCon.Api =bqApiSQLNet
myCon.Database = bqDatabaseSQLServer
myCon.HostName ="PlutoSQLSVR"
myCon.SaveAs("c:\\Program Files\\Hyperion\\BIPlus\\data\\Open Catalog Extensions\\PlutoSQL.oce")
//Now use this connection in  a datamodel
ActiveDocument.Sections["SalesQuery"].DataModel.Connection.Open("c:\\Program Files\\Hyperion\\BIPlus\\data\\Open Catalog Extensions\\PlutoSQL.oce")