Kalau pake mysql dengan vb 6 biasanya gua install odbcnya dulu baru
gua bikin script seperti ini :
Public Function SQLConnection() As Boolean
On Error GoTo SalahConnect
Set conMRIBill = New ADODB.Connection
With conMRIBill
ini untuk script login ( digabung dgn form login)
'.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" &
ServerAddress & ";DATABASE=" & DatabaseName & ";" & "UID=" &
mvarUserName & ";PWD=" & mvarPassWord & "; OPTION=16427"
ini bisa langsung di coba ( kita udah tau nama server, user, and password )
.ConnectionString = "DRIVER={MySQL ODBC 3.51
Driver};SERVER=i-made;DATABASE=mridbf;UID=root;PWD=gading;
OPTION=16427"
.CursorLocation = adUseServer
.ConnectionTimeout = 60
.Open
End With
SQLConnection = True
Exit Function
SalahConnect:
SQLConnection = False
End Function
ok gitu aja yang gua tau (CMIIW )
On 1/31/07, Adit Smith <[EMAIL PROTECTED]> wrote:
> Pake ODBC dong !
> ODBC itu jembatan dari VB ke mySQL. Di VB nya pake tool yang namanya ODBC
> Driver supaya bisa konek ke ODBC nya. Nah, dari ODBC nya dia bakal nyambung
> ke MySQL.
>
>
>
> ---------------------------------
> The fish are biting.
> Get more visitors on your site using Yahoo! Search Marketing.
>
> [Non-text portions of this message have been removed]
>
>
>
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##
## Jaket ITCENTER tersedia di http://shop.itcenter.or.id
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
