mysql连接中的ODBC驱动程序错误 [英] ODBC Driver Error in mysql connection

问题描述

我在vb.net中创建了一个应用程序。应用程序在localhost中运行顺利。虽然我在另一台服务器上托管了该应用程序。它正在获取错误

Hi,

I created an application in vb.net.The application is working smoothly in localhost.While I hosted the application in another server.It is getting an error

"System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

ODBC连接字符串是

The ODBC Connection String is

<add name="CStringODBC" connectionstring="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=17.19.18.20;user id=testUser;Password=123456;database=testdb;OPTION=3;" providername="System.Data.Odbc" />

请帮助

Please help

推荐答案

您要么没有在主机或帐户上定义数据源运行程序没有看到它。



确保在其他服务器上定义了DSN。您可以将数据源设置为系统数据源，以便所有用户都可以看到。



还要检查您是否使用了正确版本的ODBC驱动程序。如果应用程序是32位然后32位DSN和64位64位DSN。

You either don't have the datasource defined on the Host machine or the account running the program doesn't see it.

Ensure that the DSN is defined on the other server. You can make the data source a system data source in order to be visible to all users.

Also check that you're using the correct version of the ODBC driver. If the app is 32 bit then 32 bit DSN and for 64 bit a 64 bit DSN.

这篇关于mysql连接中的ODBC驱动程序错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！