What’s parameters setting and reference sequence for application program access DBMaker? (DBMR2057)

~ 0 min
2016-03-09 10:02

Connection String not only include the essential information for connect to Database but also include some correlative connection option for Database setting, such as LCODE Database Character encoding setting, The Transaction isolation level(SQL_TXN_ISOLATION) setting, Auto-Commit mode status on or off (SQL_AUTOCOMMIT) setting ,etc.

SQLSetConnectOption function used to set connection option, For example:

You can set CLILCODE use keyword in dmconfig.ini or “set CLIENT_CHAR_SET ' Character Encoding' in AP.

For example:

In dmconfig.ini:

DB_CLILCODE=GBK;

In PHP program:

SET CLIENT_CHAR_SET GBK;

You can choose one of the methods, using the dmconfig keyword DB_IsoLv or set in AP by “SQLSetConnectOption SQL_TXN_ISOLATION”.

For example:

In dmconfig.ini

DB_ISOLV = 1 ;( 1,2,3,4 four options)

In ODBC program:

SQLSetConnectOption (hdbc, SQL_TXN_ISOLATION, SQL_TXN_ READ_UNCOMMITTED)

SQLSetConnectOption (hdbc, SQL_TXN_ISOLATION, SQL_TXN_READ_COMMITTED)

SQLSetConnectOption (hdbc, SQL_TXN_ISOLATION, SQL_TXN_REPEATABLE_READ)

SQLSetConnectOption (hdbc, SQL_TXN_ISOLATION, SQL_TXN_ SERIALIZABLE)

You can set in AP by “SQLSetConnectOption “function to set SQL_AUTOCOMMIT.

In ODBC program:

SQLSetConnectOption (hdbc, SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF);

SQLSetConnectOption (hdbc, SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_ON);

If these connection option information are included on connection string, application program will be access Connection String directly, otherwise access the information from dbmconfig.ini.

 

Version: DBMaker 5.1.1

Product: Normal, Bundle

Platform: Windows

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags