Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-binary-issues.html
In these situations, it becomes practically impossible for the connector to be able to correctly identify the correct metadata. However, some existing applications may encounter issues with this change and can use a connection string option to ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-writing.html
To write a file to a database, we need to convert the file to a byte array, then use the byte array as a parameter to an INSERT query. After assigning the byte array as a parameter of the MySqlCommand object, the ExecuteNonQuery method is called ...
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 ...