Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-borland-delphi.html
Also, here is some potentially useful Delphi code that sets up both an ODBC entry and a BDE entry for Connector/ODBC. The BDE entry requires a BDE Alias Editor that is free at a Delphi Super Page near you.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-coldfusion.html
The following information is taken from the ColdFusion documentation: Use the following information to configure ColdFusion Server for Linux to use the unixODBC driver with Connector/ODBC for MySQL data sources. ColdFusion version 4.5.1 lets you ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
Some external articles and tips that may be useful when using Access, ODBC and Connector/ODBC: Read How to Trap ODBC Login Error Messages in Access Optimizing Access ODBC Applications Optimizing for Client/Server Performance Tips for Converting ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-ado.html
When you are coding with the ADO API and Connector/ODBC, you need to pay attention to some default properties that aren't supported by the MySQL server. For example, using the CursorLocation Property as adUseServer returns a result of −1 for the ...To find the number of rows affected by a specific SQL statement in ADO, use the RecordsAffected property in the ADO execute ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-connect.html
import _mysql_connector ccnx = _mysql_connector.MySQL() ccnx.connect(user='scott', password='password', host='127.0.0.1', database='employees') ccnx.close() connect() supports the following arguments: host, user, password, database, port, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-fields.html
Returns a list of tuples, one tuple per column Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server. Syntax: field_info = ccnx.fetch_fields() Fetches column information for the active result set.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-fetch-row.html
ccnx.query('SELECT CURRENT_USER(), 1 + 3, NOW()') row = ccnx.fetch_row() print(row) ccnx.free_result() Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server. Syntax: row = ccnx.fetch_row() Fetches the next row from ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-mysql.html
Syntax: ccnx = _mysql_connector.MySQL(args) The MySQL class is used to open and manage a connection to a MySQL server (referred to elsewhere in this reference as “the MySQL instance”). It is also used to send commands and SQL statements and ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-next-result.html
Raises a MySQLInterfaceError exception for any MySQL error returned by the MySQL server. Syntax: ccnx.next_result() Initiates the next result set for a statement string that produced multiple result sets.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-ping.html
Syntax: alive = ccnx.ping() Returns True or False to indicate whether the connection to the MySQL server is working.