Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb.html
This section contains simple examples of the use of Connector/ODBC with ADO, DAO and RDO.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming.html
This includes, but is not limited to, Microsoft support languages (including Visual Basic, C# and interfaces such as ODBC.NET), Perl (through the DBI module, and the DBD::ODBC driver). With a suitable ODBC Manager and the Connector/ODBC driver ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-import.html
Select the tables you want to import from this Import Objects dialog (or click Select All), and then click OK. To import tables from MySQL to Access, follow these instructions: Open the Access database into which that you want to import MySQL data.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools.html
This section contains guides and help on using Connector/ODBC with various ODBC-compatible tools and applications, including Microsoft Word, Microsoft Excel and Adobe/Macromedia ColdFusion. Once you have configured your Connector/ODBC DSN, you can ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-api.html
For the complete ODBC API reference, please refer to the ODBC Programmer's Reference at http://msdn.microsoft.com/en-us/library/ms714177.aspx. An application can call SQLGetInfo function to obtain conformance information about Connector/ODBC. To ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference.html
This section provides reference material for the Connector/ODBC API, showing supported functions and methods, supported MySQL column types and the corresponding native type in Connector/ODBC, and the error codes returned by Connector/ODBC when a ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-borland-cppbuilder.html
BDE, however, does not seem to recognize primary keys, only the index named PRIMARY, although this has not been a problem. The only known problem is that when the table schema changes, query fields are not updated.
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-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-visualbasic.html
This means that some queries like SHOW PROCESSLIST do not work properly. To be able to update a table, you must define a primary key for the table. The fix is to use OPTION=16384 in the ODBC connect string or to select the Change BIGINT columns to ...