Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-rdo.html
The following RDO (Remote Data Objects) example creates a table my_rdo and demonstrates the use of rs.addNew and rs.update. SQL = "select * from my_rdo" Set rs = cn.OpenResultset(SQL, rdOpenStatic, rdConcurRowVer, rdExecDirect) Do Until rs.EOF For ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-export.html
Click either the File Data Source or Machine Data Source tab, and then double-click the Connector/ODBC DSN to which you want to export your table. To define a new DSN for Connector/ODBC instead, click New and follow the instructions in Section 5.3, ... Important Make sure that the information that you are exporting to the MySQL table is valid for the corresponding MySQL data ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples.html
Once you have configured a DSN to provide access to a database, how you access and use that connection is dependent on the application or programming language. As ODBC is a standardized interface, any application or language that supports ODBC can ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-installation-binary-macos.html
macOS is based on the FreeBSD operating system, and you can normally use the MySQL network port for connecting to MySQL servers on other hosts. Installing the Connector/ODBC driver lets you connect to MySQL databases on any platform through the ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-errorcodes.html
The following tables lists the error codes returned by Connector/ODBC apart from the server errors.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-visualbasic.html
The fix is to use OPTION=16384 in the ODBC connect string or to select the Change BIGINT columns to INT option in the Connector/ODBC connect screen. To be able to update a table, you must define a primary key for the table. This means that some ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-clientflag.html
This class provides constants defining MySQL client flags that can be used when the connection is established to configure the session. >>> import mysql.connector >>> mysql.connector.ClientFlag.FOUND_ROWS 2 See Section 10.2.32, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-autocommit.html
This property can be assigned a value of True or False to enable or disable the autocommit feature of MySQL. The property can be invoked to retrieve the current autocommit setting. When the autocommit is turned off, you must commit transactions ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-can-consume-results.html
This property indicates the value of the consume_results connection parameter that controls whether result sets produced by queries are automatically read and discarded.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-charset.html
This property returns a string indicating which character set is used for the connection, whether or not it is connected.