SAP DB:ODBC Przewodnik Instalacji Pobierz pdf (Strona 114)

mxODBC - Python ODBC Database Interface

# string

db = mx.ODBC.Windows.DriverConnect('DSN=mydb;UID=uid;PWD=pwd')

6.7 Connection Object Methods

.close()

Close the connection now (rather than automatically at garbage collection

time). The connection will be unusable from this point on; an

Error (or

subclass) exception will be raised if any operation is attempted with the

connection. The same applies to all cursor objects trying to use the

connection.

.commit()

Commit any pending changes and implicitly start a new transaction.

For connections which do not provide transaction support or operate in auto-

commit mode, this method does nothing.

.cursor(name=None, cursor_options=())

Constructs a new Cursor Object with the given name using the connection and

initializes any provided cursor options.

If no name is given, the ODBC driver or database backend will determine a

unique name on its own. You can query this name with

cursor.getcursorname() (see the Cursor Object section 7).

The

cursor_options may be given as list of (option, value) tuples. These

are then passed to the cursor's

cursor.setconnectoption() API (see the

Cursor Object

section 7) and allow configuring the cursor upfront to a specific

need.

.getconnectoption(option)

Get information about the connection.

option must be an integer. Suitable option values are available through the

SQL object (see the Constants section 10.5 for details).

The method returns the data as 32-bit integer. It is up to the user to decode

the integer value using the SQL defines available through the

SQL constant.

This API gives you a very wide range of information about the underlying

database and its capabilities. See the ODBC SQLGetConnectAttr API

Documentation for more information.

.getinfo(info_id)

Get general information about the database, the ODBC driver and the ODBC

driver manager.

The

info_id must be an integer. Suitable values are available through the SQL

object (see the Constants

section 10.5 for details).

1 2 ... 109 110 111 112 113 114 115 116 117 118 119 ... 224 225

Komentarze do niniejszej Instrukcji

Brak uwag

SAP DB:ODBC Przewodnik Instalacji Strona 114

Komentarze do niniejszej Instrukcji

Powiązane produkty i podręczniki dla Oprogramowanie SAP DB:ODBC