DBPowerSuite 7.9 Application Programming Interface
ODBC

#

Inline

Pure Virtual

Virtual

Method

Description

1

OConnectionSet()

Constructor

2

OConnectionSet(ODBCMessages* messages)

Constructor

3

ps_int32 oConnect(HENV henv, HDBC hdbc)

Connect to the ODBC Data Source

4

ps_int32 oConnect(const ps_char* dsn, const ps_char* username = NULL, const ps_char* password = NULL, const ps_char* application_name = NULL, const ps_char* server_name = NULL, const ps_char* other_connection_attributes = NULL)

Connect to the ODBC Data Source

5

ps_int32 oDisconnect()

Stop all Queries and Disconnect from the Data Source

6

ps_int32 oDoesConnectionExist() const

Does Your ODBC OConnection Exist?

7

ps_int32 oDoesEnvironmentExist() const

Does your ODBC Environment Exist?

8

ps_int32 oDoesStatementExist(ps_int32 index) const

Does a Statement Exist?

9

ps_int32 oForceDBBrand(ps_int32 db_brand = DB_BRAND_UNKNOWN)

Force the Brand of Database

10

OCatalogStatement & oGetCatalogStatement() const

11

OCatalogStatement * oGetCatalogStatementPtr() const

12

Mutex * oGetConnectMutex() const

13

ps_int8 oGetConnectedSw() const

Are You Connected to ODBC Data Source?

14

OConnection & oGetConnection() const

15

OConnection * oGetConnectionPtr() const

16

ps_int32 oGetConnectionType() const

17

ps_int32 oGetDSN(ps_char* dsn) const

Get the Name of ODBC Data Source

18

ps_int32 oGetDeadlockWaitTimeBetweenRetries() const

19

OEnvironment & oGetEnvironment() const

20

OEnvironment * oGetEnvironmentPtr() const

21

Messages * oGetMessages() const

22

ps_int32 oGetNumberOfDeadlockRetries() const

23

ps_int32 oGetNumberOfODBCErrors() const

Get the Total Number Errors Detected for all Objects in the OConnectionSet

24

ps_int32 oGetPacketSize() const

25

ps_int32 oGetQuotedIdentifier(ps_char* quoted_identifer) const

Get the Quoted Identifier the ODBC Connection

26

ps_int8 oGetQuotedIdentifiersSw() const

27

OStatement & oGetStatement(ps_int32 index) const

28

OStatement * oGetStatementPtr(ps_int32 index) const

29

ps_int32 oGetStatementType() const

30

UFile * oGetUFile() const

31

ps_time oGetUTTimeConnected() const

Get the UTC Time When You Opened the ODBC Connection

32

ps_int8 oGetUseTimeoutsSw() const

33

ps_void * oGetUserData() const

34

ps_int32 oSetConnectMutex(Mutex* connect_mutex = NULL)

Set the Connection Mutex Lock

35

ps_int32 oSetConnectionType(ps_int32 connection_type = ODBC_NORMAL_CONNECTION_TYPE)

Set the Type Connection the OConnectionSet Creates

36

ps_int32 oSetDeadlockWaitTimeBetweenRetries(ps_int32 number_of_microseconds = ODBC_OSTMT_DEADLOCK_WAIT_TIME)

Set Wait Time Before Resending a SQL Command After Deadlocked

37

ps_int32 oSetMessages(ODBCMessages* messages = NULL)

Set the ODBCMessages Object for the OConnectionSet and all its Created Objects

38

ps_int32 oSetNumberOfDeadlockRetries(ps_int32 number_of_retries = ODBC_OSTMT_DEADLOCK_RETRIES)

Set the Number of Times This Class Resends a SQL Command Upon Receiving a Deadlock Victim Error

39

ps_int32 oSetNumberOfStatements(ps_int32 number_of_statements_for_future_connections = 1)

Set the Number of ODBC Statements the OConnectionSet Creates

40

ps_int32 oSetPacketSize(ps_int32 packet_size_in_bytes)

Set the Network Communication Packet Size (Bytes)

41

ps_int32 oSetQuotedIdentifiersSw(ps_int8 sw = 1)

42

ps_int32 oSetStatementType(ps_int32 statement_type = ODBC_NORMAL_STATEMENT_TYPE)

43

ps_int32 oSetUFile(UFile* os_file)

Set the UFile for the OConnectionSet

44

ps_int32 oSetUserData(ps_void* user_data)

Set User Data on a OConnectionSet

45

ps_int32 oUseTimeouts(ps_int8 use_timeouts_sw = 1, ps_int32 login_timeout_seconds = ODBC_OCONN_LOGIN_TIMEOUT, ps_int32 query_timeout_seconds = ODBC_OSTMT_QUERY_TIMEOUT)

Turn On/Off Timeout Ability

46

~OConnectionSet()

Destructor