Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
To improve the integration between Microsoft Access and MySQL through Connector/ODBC: For all versions of Access, enable the Connector/ODBC Return matching rows option. If you are using Connector/ODBC to link to a table that has a BIGINT column, ...
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 ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualinterdev.html
Try selecting the Change BIGINT columns to INT option in the Connector/ODBC connect screen. If you have a BIGINT in your result, you may get the error [Microsoft][ODBC Driver Manager] Driver does not support this parameter.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-close.html
Syntax: ccnx.close() Closes the MySQL connection. ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-get-host-info.html
Syntax: info = ccnx.get_host_info() Returns a description of the type of connection in use as a string.
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.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-thread-id.html
Syntax: thread_id = ccnx.thread_id() Returns the current thread or connection ID.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-operationalerror.html
For example: too many connections; a host name could not be resolved; bad handshake; server is shutting down, communication errors. This exception is raised for errors which are related to MySQL's operations.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-poolerror.html
This exception is raised for connection pool errors. errors.PoolError is a subclass of errors.Error. ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-warning.html
This exception is used for reporting important warnings, however, Connector/Python does not use it. Consider using either more strict Server SQL Modes or the raise_on_warnings connection argument to make Connector/Python raise errors when your ...