澳门银河网上官方赌场_老品牌值得信赖

ITKeyword,专注技术干货聚合推荐

注册 | 登录

c# - .NET can′t connect to MySQL with ODBC 5.3?

itPublisher 分享于

2020腾讯云双十一活动,全年最低!!!(领取3500元代金券),
地址https://cloud.tencent.com/act/cps/redirect?redirect=1073

【阿里云】双十一活动,全年抄底价,限时3天!(老用户也有),
入口地址https://www.aliyun.com/1111/home

推荐:asp.net mysql c# 实用mysql

在网上看到一篇关于Asp.net和mysql的文章,mysql安装和.NET中连接MySQL数据库的方法详细请看《ASP.NET+MySQL简明图示入门》http://www.yesky.com/431/1944431.sh

up vote 0 down vote favorite I have a ASP.NET webform .NET 4.5 website that uses MySQL ODBC to communicate with the MySQL Database. This is working just fine with the 5.1.13 32bit driver but if I uninslla this and install 5.3.4 32bit driver I get the following exception when connecting : A first chance exception of type 'System.Data.Odbc.OdbcException' occurred in System.Data.dll Additional information: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified The connectionstring Im using is this DRIVER={MySQL ODBC 5.3 `Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=mydatabase;USER=myuser;PASSWORD=mypassword;OPTION=3`

All I changed is from MySQL ODBC 5.1 to MySQL ODBC 5.3. this is the code that fails(where I can see the correct(above) connectionstring. dataAdapter = new OdbcDataAdapter(inCommandObj);

mainConnection.Op

推荐:asp.net c# mysql存储过程

//asp.net C#

//myql5.0以上 using System.Data; //CommandType

, ParameterDirection using System.Diagnostics; //Debug , visual web developer中调试窗口

en();

Why is this not working? c# mysql asp.net .net
  asked Mar 18 '15 at 18:03 Banshee 6,275 20 79 149



 |  1 Answers

up vote 1 down vote ---Accepted---Accepted---Accepted---

try with driver name "MySQL ODBC 5.3 ANSI Driver" updated connection string: Driver={MySQL ODBC 5.3 ANSI Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=mydatabase;USER=myuser;PASSWORD=mypassword;OPTION=3


  answered Mar 18 '15 at 18:26 Raushan Kuamr Jha 279 2 4



 | 

推荐:关于C#(ASP.net)存取MySQL LongText字段的心得

? 关于C#(ASP.net)存取MySQL LongText字段的心得 ? 1.LongText字段是MySQL用于存储超长字符串的数据库类型,有点类似MSSQL的memo。 ? 2.Connector/NET读取Lo

up vote 0 down vote favorite I have a ASP.NET webform .NET 4.5 website that uses MySQL ODBC to communicate with the MySQL Database. This is working just fine with the 5.1.13 32bit

相关阅读排行


相关内容推荐

最新文章

×

×

请激活账号

为了能正常使用评论、编辑功能及以后陆续为用户提供的其他产品,请激活账号。

您的注册邮箱: 修改

重新发送激活邮件 进入我的邮箱

如果您没有收到激活邮件,请注意检查垃圾箱。

澳门银河网上官方赌场