VB.Net 과 MySql 연동하기

VB.Net 과 MySql 연동하기


1.아래 URL을 클릭하여 MySQL ODBC 5.1 Driver 를 설치한다.

다운로드 페이지
http://dev.mysql.com/downloads/connector/odbc/5.1.html

모든 드라이버 및 컨넥터 다운로드
http://dev.mysql.com/downloads/

2. 아래 소스를 실행시켜 본다.

Dim myConnString As String = "DRIVER={MySQL ODBC 5.1 Driver};" + _                                      "SERVER=121.125.68.80;" + _                                      "Port=3306;" + _                                      "Option=16384;" + _                                      "DATABASE=test;" + _                                      "UID=ud4m;" + _                                      "PASSWORD=3609;"         Dim myConnection As OdbcConnection         myConnection = New OdbcConnection(myConnString)         Dim sql As String = "SELECT dname FROM dept; "         Dim cmd As OdbcCommand = New OdbcCommand(sql, myConnection)         myConnection.Open()         Dim rd As String         rd = cmd.ExecuteScalar         MsgBox(rd)         myConnection.Close()

 

Dim dbSql As String = "insert into dept(dname) values ('test');" Dim dbCmd As OdbcCommand = New OdbcCommand(dbSql, myConnString ) myConnection.Open() dbCmd.ExecuteNonQuery() myConnection.Close()

 
3. 만약 [Mysql] [ODBC 5.1 Driver] Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this Mysql
   이런 에러가 난다면 아래 URL의 작업을 시행해 준다.

db를 a라는 사용자에게 192.168.0.1~255까지 허용하려면,

mysql> use mysql;
mysql> update db set host='192.168.0.%' where user='a';
mysql> update user set host='192.168.0.%' where user='a'; 
mysql> flush privileges;

host='%'  를 입력하면 모든 IP에서 접근이 가능