Search Results
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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/connectors/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 ...
https://dev.mysql.com/doc/connectors/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 ...