Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-crystal-source.html
The first option is to use Connector/ODBC as an ADO data source when designing your report. If you choose to design your reports using Connector/ODBC, it can be downloaded from dev.mysql.com. When creating a report in Crystal Reports there are two ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tablecaching.html
Configuration To enable table caching, add 'table cache = true' to the connection string. Optionally, specify the 'Default Table Cache Age' connection string option, which represents the number of seconds a table is cached before the cached data is ... Table caching is a feature that can be used to cache slow-changing datasets on the client ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql-custom-listeners.html
To build custom listeners that work with the MySQL Connector/NET Trace Source, it is necessary to understand the key methods used, and the event data formats used. This value is defined by the MySqlTraceEventType public enum contained in the ...The ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-efmodel-ddl.html
Minimally, you will need Microsoft Visual Studio 2017 and MySQL Connector/NET 6.10 to perform this tutorial. In the Generate Database Wizard dialog select an existing connection, or create a new connection to a server. This tutorial demonstrates ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
For the purposes of this tutorial, you will create a simple stored procedure to see how it can be called from MySQL Connector/NET. Having confirmed that the stored procedure is present and correct, you can see how to access it from Connector/NET.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-unix.html
On Unix, you configure DSN entries directly in the odbc.ini file. For example, if your odbc.ini file is located in /usr/local/etc, set the environment variables like this: export ODBCINI=/usr/local/etc/odbc.ini export ODBCSYSINI=/usr/local/etc .
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-dao.html
The following DAO (Data Access Objects) example creates a table my_dao and demonstrates the use of rs.addNew, rs.update, and result set scrolling. Set rs = conn.OpenRecordset("my_dao") rs.Edit rs!Name = "updated-string" rs.Update rs.Close 'fetch ...
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 ...