MySQL ODBC 配置 [英] MySQL ODBC configuration

问题描述

我已经设法让我的 Access 作为 MySQL 的前端工作.我设法通过连接字符串使其工作，但由于代码中的某些细节，我想将 DSN 配置保存为用户 DSN.

我遇到了一个具体问题.我需要在我的连接字符串中使用 option=3 因为没有 option=3 我得到错误:Microsoft Jet 数据库引擎停止了这个过程，因为你和另一个用户正在尝试同时更改相同的数据.如果我在我的连接字符串中包含 option=3 一切正常.问题是，在 Mysql Connector/ODBC 数据源配置中，我不知道哪个复选框/选项代表 option=3

解决方案

关于这个的文档在这里:

I have managed to make my Access work as a frontend for MySQL. I have managed to make it work through connection string but because some specifics in code i would like to save DSN configuration as user DSN.

I have ran into one specific problem. I need to use option=3 inside my connection string because without option=3 i get error: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. If i include option=3 in my connection string everything works well. The thing is, in Mysql Connector/ODBC data source configuration i do not know which checkbox/option represents option=3

解决方案

The doc about this is here : Connector/ODBC Connection Parameters

option=3 looks deprecated as specified in this answer :

Option=3; corresponded to FLAG_FIELD_LENGTH (1) + FLAG_FOUND_ROWS (2)

It looks indeed deprecated as in the doc I can't find any reference to FLAG_FIELD_LENGTH

We can thus assume that the flag you really need is FLAG_FOUND_ROWS

According to the doc, the GUI option for this flag is

Return matched rows instead of affected rows

这篇关于MySQL ODBC 配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！