我链接数据库始终不行,老是读不出数据。
protected void SetBind()
{
String SqlCmd = "select address1 from tabMembers";
OdbcConnection conn = new OdbcConnection("Driver={MySQL ODBC 3.51?Driver};Server=.;Port=3306;Option=131072;Stmt=;Database=test;Uid=test;Pwd=test;");
OdbcDataAdapter da = new OdbcDataAdapter(SqlCmd, conn);
DataSet ds = new DataSet();
da.Fill(ds, "tabMembers"); this.GridView1.DataSource = ds.Tables["tabMembers"];
this.GridView1.DataBind();
}每次都是出现ERROR [IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
是什么问题啊?是否还需要做什么设置呢?
protected void SetBind()
{
String SqlCmd = "select address1 from tabMembers";
OdbcConnection conn = new OdbcConnection("Driver={MySQL ODBC 3.51?Driver};Server=.;Port=3306;Option=131072;Stmt=;Database=test;Uid=test;Pwd=test;");
OdbcDataAdapter da = new OdbcDataAdapter(SqlCmd, conn);
DataSet ds = new DataSet();
da.Fill(ds, "tabMembers"); this.GridView1.DataSource = ds.Tables["tabMembers"];
this.GridView1.DataBind();
}每次都是出现ERROR [IM002] [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
是什么问题啊?是否还需要做什么设置呢?
解决方案 »
- box-z.com 这样的价格比较怎么实现的?
- 关于aspnetpager在傲游浏览器运行的问题
- 无刷新上传
- ScriptManager.RegisterClientScriptBlock问题,页面跳转不过去
- 图片按钮按下去后可不可以不刷新页面?
- DataGrid1.CurrentPageIndex = e.NewPageIndex;这个怎么写不上去啊.
- 怎样用代码设置打印里的选项
- .net页面动态数据
- SmartNavigation 的问题
- 我想在Web.config里设置一些unicode格式的字符,不知道要如何做?
- C# web页面中使用gridview更新数据库
- ENcode 问题!急~~~~~~~~~~
或者是没有配置好,重新配置一下.建议重新安装后配置.
ODBC里面连接的上么?
检查你的连接字符串:
参考: http://www.connectionstrings.com/?carrier=mysql
This is a compiled connection strings reference list on how to connect to MySQL.
MyODBC
MyODBC 2.50 Local database
Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase;
MyODBC 2.50 Remote database
Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=; Database=myDataBase;Uid=myUsername;Pwd=myPassword;
MyODBC 3.51 Local database
Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;
MyODBC 3.51 Remote database
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;
OLE DB, OleDbConnection (.NET)
Standard
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;
Connector/Net 1.0 (.NET)
Standard
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Default port is 3306.
Specifying port
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Named pipes
Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
It is the port value of -1 that tells the driver to use named pipes network protocol.
MySqlConnection (.NET)
eInfoDesigns.dbProvider
Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Command Logging=false;
SevenObjects MySqlClient (.NET)
Standard
Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase;
Core Labs MySQLDirect (.NET)
Standard
User ID=root;Password=myPassword;Host=localhost;Port=3306;Database=myDataBase; Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;
MySQLDriverCS (.NET)
Standard
Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";
This is a free simple .NET compliant MySQL driver.