2.5.59 ConnGrbitDbtOledb

The ConnGrbitDbtOledb structure specifies the external connection properties for an OLE DB data connection.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

dbost

A

B

C

D

E

F

G

H

I

J

dbost (3 bits): An unsigned integer that specifies the OLE DB command type. This field applies to the database command strings that are saved with the parent records. MUST be a value from the following table:

Name

Value

Meaning

CMDNULL

0x0

The string is not specified.

CMDCUBE

0x1

The string specifies the name of a cube within an OLAP database, see also OLAP Connections.

CMDSQL

0x2

The string specifies an SQL statement.

CMDTABLE

0x3

The string specifies a database table name.

CMDDEFALT

0x4

The string specifies a statement in the default language of the database.

CMDSPLIST

0x5

The string specifies a list from a Web-based data provider.

A - fLocalConn (1 bit): A bit that specifies which connection string to use for this external connection. MUST be a value from the following table:

Value

Meaning

0x0

Uses the main connection string, as specified by a value of 0 in the fLocal field in OleDbConn, or by a value of 0 or 1 in the rgIOleDbValid of a DConnConnectionOleDb.

0x1

Uses the alternate connection string, as specified by a value of 1 in the fLocal field in OleDbConn, or by a value of 2 or 3 in the rgIOleDbValid of a DConnConnectionOleDb.

     

B - fNoRefreshCube (1 bit):  A bit that specifies whether any local cache of data from the OLAP data source is to be flushed when the a refresh is done. The value zero specifies any local cache of data from the OLAP data source is to be flushed when the a refresh is done. MUST be zero and MUST be ignored if the dbost field does not equal 0x1.

C - fUseOfficeLcid (1 bit):  A bit that specifies whether the user’s locale information is provided to the OLAP data source for retrieval of translated data and errors. MUST be zero and MUST be ignored if the dbost field does not equal 0x1.

D - fSrvFmtNum (1 bit):  A bit that specifies whether to apply OLAP data source number formatting to the PivotTable. MUST be zero and MUST be ignored if the dbost field does not equal 0x1.

E - fSrvFmtBack (1 bit):  A bit that specifies whether to apply OLAP data source fill colors to the PivotTable. MUST be zero and MUST be ignored if the dbost field does not equal 0x1.

F - fSrvFmtFore (1 bit):  A bit that specifies whether to apply OLAP data source font colors to the PivotTable. MUST be zero and MUST be ignored if the dbost field does not equal 0x1.

G - fSrvFmtFlags (1 bit):  A bit that specifies whether to apply OLAP data source  font formatting to the PivotTable. MUST be zero and MUST be ignored if the dbost field does not equal 0x1.

H - fSupportsLangCellProp (1 bit):  A bit that specifies whether the user’s locale information is provided to the OLAP data source to support member (2) localization. MUST be zero and MUST be ignored if the dbost field does not equal 0x1.

I - fSrvSupportsClientCube (1 bit): A bit that specifies that the server supports local embedded data storage.

J - reserved (4 bits): MUST be zero and MUST be ignored.