Teman kalo buat MySql 5.0 pake driver MyODBC 5.1 ada di ww.mysql.com. coba download dulu tapi kalo pake MySQL versi 4 kebawah pakeMyODBC 3.51 bisa.
----- Original Message ---- From: Naufal Mumtaz Ramadhan <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [email protected] Sent: Thursday, November 16, 2006 3:16:49 PM Subject: Re: [indoprog-vb] Koneksi database MySql 5.0 dengan VB6 melalui ADODB coba spt dibawah ini : Public cn As ADODB.Connection Public rs As ADODB.Recordset Private sub form_load() db_name = "Keuangan" db_server = "localhost" db_port = "" 'default port is 3306 db_user = "root" db_pass = "" ' BukaServer ' Open without ODBC in Control Panel constr = "Provider=MSDASQL. 1;Password= ;Persist Security Info=True;User ID=;Extended Properties=" & Chr$(34) & "DRIVER={MySQL ODBC 3.51 Driver};DESC= ;DATABASE= " & db_name & ";SERVER=" & db_server & ";UID=" & db_user & ";PASSWORD=" & db_pass & ";PORT=" & db_port & ";OPTION=16387; STMT=;" & Chr$(34) Set cn = New ADODB.Connection cn.Open constr Set rs = New ADODB.Recordset rs.Open "select * from BukuKepala order by no", cn, adOpenDynamic, adLockOptimistic end sub Andristyanto Sagitta Pratama <aiki_hokage37@ yahoo.co. id> wrote: Salam, Kk2 programer yang baik. Saya mau tanya nih. Gimana sih cara koneksi mysql 5.0 dengan vb6 di ADODB Connection String? Kalo g salah butuh driver yah..? Kalo punya drivernya, boleh minta g? Soalnya driver yang saya download itu error. Makasih ya Kk2. ____________ _________ _________ _________ _________ ________ Kunjungi halaman depan Yahoo! Indonesia yang baru! http://id.yahoo. com/ Send instant messages to your online friends http://uk.messenger .yahoo.com Send instant messages to your online friends http://uk.messenger .yahoo.com Send instant messages to your online friends http://uk.messenger .yahoo.com [Non-text portions of this message have been removed] <!-- #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0; } #ygrp-tpmsgs{ font-family:Arial; clear:both; } #ygrp-vitnav{ padding-top:10px; font-family:Verdana; font-size:77%; margin:0; } #ygrp-vitnav a{ padding:0 1px; } #ygrp-actbar{ clear:both; margin:25px 0; white-space:nowrap; color:#666; text-align:right; } #ygrp-actbar .left{ float:left; white-space:nowrap; } .bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana; font-size:77%; padding:15px 0; } #ygrp-ft{ font-family:verdana; font-size:77%; border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px; } #ygrp-vital{ background-color:#e0ecee; margin-bottom:20px; padding:2px 0 8px 8px; } #ygrp-vital #vithd{ font-size:77%; font-family:Verdana; font-weight:bold; color:#333; text-transform:uppercase; } #ygrp-vital ul{ padding:0; margin:2px 0; } #ygrp-vital ul li{ list-style-type:none; clear:both; border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold; color:#ff7900; float:right; width:2em; text-align:right; padding-right:.5em; } #ygrp-vital ul li .cat{ font-weight:bold; } #ygrp-vital a { text-decoration:none; } #ygrp-vital a:hover{ text-decoration:underline; } #ygrp-sponsor #hd{ color:#999; font-size:77%; } #ygrp-sponsor #ov{ padding:6px 13px; background-color:#e0ecee; margin-bottom:20px; } #ygrp-sponsor #ov ul{ padding:0 0 0 8px; margin:0; } #ygrp-sponsor #ov li{ list-style-type:square; padding:6px 0; font-size:77%; } #ygrp-sponsor #ov li a{ text-decoration:none; font-size:130%; } #ygrp-sponsor #nc { background-color:#eee; margin-bottom:20px; padding:0 8px; } #ygrp-sponsor .ad{ padding:8px 0; } #ygrp-sponsor .ad #hd1{ font-family:Arial; font-weight:bold; color:#628c2a; font-size:100%; line-height:122%; } #ygrp-sponsor .ad a{ text-decoration:none; } #ygrp-sponsor .ad a:hover{ text-decoration:underline; } #ygrp-sponsor .ad p{ margin:0; } o {font-size:0;} .MsoNormal { margin:0 0 0 0; } #ygrp-text tt{ font-size:120%; } blockquote{margin:0 0 0 4px;} .replbq {margin:4;} --> ____________________________________________________________________________________ Sponsored Link Compare mortgage rates for today. Get up to 5 free quotes. Www2.nextag.com [Non-text portions of this message have been removed]
