求ASP.NET中的MYSQL连接字符串
解决方案 »
- ASP.NET 定时提醒的功能如何实现?
- 读取txt文本问题!
- 超连接中使用javascript的问题???????????
- 如何过滤掉数据库中的html代码??
- 如果使用在服务端使用动态(html端的CheckBox),我在服务器是动态加载的
- 请推荐ASP.NET项目实战方面的图书
- 谁能解决考试系统交卷时的并发问题,高分相送,MONEY也可以!
- 调用用户控件问题 高手请进来救我
- asp.net调试,在线等待????????????????????????????
- 谁有http://www.csdn.net/develop/Read_Article.asp?Id=15245上讲的js文件
- 商品展示架-----是怎么实现的
- 问:在ASP.NET中MYSQL何乱?
To connect to a local databaseoConn.Open "Driver={mySQL};" & _
"Server=MyServerName;" & _
"Option=16834;" & _
"Database=mydb;"To connect to a remote databaseoConn.Open "Driver={mySQL};" & _
"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"For more information, see: Programs Known to Work with MyODBC
Standard:"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"
MyODBC 2.50 Local database:
"Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;"
MyODBC 2.50 Remote database:
"Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"
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=UserName;Password=asdasd;"
Connector/Net 1.0 (.NET)
Standard:
"Server=Server;Database=Test;Uid=UserName;Pwd=asdasd;"
Download the driver at
http://www.connectionstrings.com