vb and sql

[complot]

mintak tolon bley??? ada sesapa tau camne nak connect vb ngan sql? any references? websites etc?kalu vb ngan access tuh, dah biasa buat..cuma xtau camne nak connect vb ngan sql..tolon sesapa..

[ekzos_pipe]

sql? ke mysql punya db, sql nih structured query language, rasanya hampir suma programing language utk connect ke database pakai arahan sql nih kan(?) kalu vb kan ada microsoft sql server dia tuh, maybe ble try kot.. vb ekzos tak tahu sangat, kalu mysql tu plak selalu ekzos guna ngan php je buat web sket2..

[complot]

thats the prob...mmg ada sqlserver tuh...tp kena connect to mysql laa..penin dah ni

[maumatika]

Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=127.0.0.1;" _
& "DATABASE=test;" _
& "UID=testuser;" _
& "PWD=12345;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
conn.Open

conn.Execute "DROP TABLE IF EXISTS report", ,

untuk command lain guna la conn.Execute command_Anda

contoh
conn.Execute "INSERT INTO Table SET nama='Maumatika'"

Arahan kene ikut mysql sql command set.
Kalau x dapat connect kene ubah prop mysql untuk bahagian user.

Selamat Berjaya...

[complot]

thanx...tp...kat mana nak dpt references???ada website etc?