无法打开mysql odbc后端作为代码的读写 [英] can not open mysql odbc backend as read-write from code

问题描述

我已经完成了两天的MySQL服务器设置。我只能通过代码保护只读连接。可以建立远程odbc连接。  MySQL工作台远程连接。我可以从访问上传表格及其所有数据。
我在代码中有一个只读连接。



我使用：
$


套装dbs_mac = OpenDatabase（" ConnectODBC32"，True，False，  ODBC; DATABASE = db; UID = ServerClient; PWD = *********; DSN = ConnectODBC32"）'CurrentDb

strSQL =" SELECT *" &安培; _

        "来自[客户信息]" &安培; _

        " ORDER BY [client_id] ASC"



设置rst_ctl = dbs_mac.OpenRecordset（strSQL，类型：= dbOpenDynaset，选项：= dbConsistent）

解决方案

Hi Xittenn，

你的意思是你无法更新MySql数据库中的数据吗？

运行代码时是否会收到任何错误消息？什么是错误消息？

最好的问候，

Terry

I have gone through my MySQL server setup for two days. I can only secure a read-only connection from code. The remote odbc connection can be established.  MySQL workbench connects remotely. I am able to upload tables and all their data, from access. I do have a read only connection in code.

I use:

Set dbs_mac = OpenDatabase("ConnectODBC32", True, False, "ODBC;DATABASE=db;UID=ServerClient;PWD=*********;DSN=ConnectODBC32") 'CurrentDb

strSQL = "SELECT *" & _
        " FROM [Client Information]" & _
        " ORDER BY [client_id] ASC"

Set rst_ctl = dbs_mac.OpenRecordset(strSQL, Type:=dbOpenDynaset, Options:=dbConsistent)

解决方案

Hi Xittenn,

Do you mean that you could not update data in MySql database from access?

Would you get any error message when running the code? What's the error message?

Best Regards,

Terry

这篇关于无法打开mysql odbc后端作为代码的读写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！