saya coba di shared hosting dengan cpanel muncul pesan dibawah :
[Mysql][ODBC 3.51 Driver Acces denied for user'root'@'202.93.37.84'(using
password: YES)
tapi kalo peke script aslinya bisa apa ya yang kurang...?
script contoh bisa dicoba :
remote mysql :
'================================
Private Sub Form_Load()
Dim sql As String
sql = "select * from Users ORDER BY id"
With Adodc1
.ConnectionString = "Driver={MySQL ODBC 3.51
Driver};Server=www.freesql.org;Port=3306;Database=dbobri;User=obri;
Password=emondyhen;Option=3;"
.RecordSource = sql
.Refresh
End With
End Sub
'===================================='
--- On Tue, 6/8/10, [email protected] <[email protected]> wrote:
From: [email protected] <[email protected]>
Subject: Re: [programmer-vb] cara/coding vb 6 konek dengan database mysql
online...?
To: [email protected]
Date: Tuesday, June 8, 2010, 11:57 PM
tidak bisanya kenapa? ada error message tidak?
kalau ada silahkan disharing.Hostingny a dedicated atau shared ?
hostingnya pakai cpanel atau non-server management ?
kalau dedicated hosting (punya ip public sendiri dan memang service
mysqlnya dibuka untuk public access seharusnya tidak jadi masalah.
Kalau pun jadi masalah kebanyakan karena manajemen hak user di Mysql
(yg bisa terhubung boleh dari IP mana saja bukan hanya localhost),
manajemen firewall dari server tersebut atau bottleneck di firewall
server tersebut.
Lain hal bila hostingnya di cpanel lalu mau konek ke server tersebut.
Kalau ada IP dedicated lebih baik langsung pakai IP daripada domain
name. lalu harus setting lagi remote database access dll.
mohon CMIIW :)
Ronald "kriwelz" Simanjuntak
Blog : http://blog. kriwelz.web. id
YM : curlyjoe_bug / imkriwelz
FB : kriw...@gmail. com
Skype,Gtalk: kriwelz
triyanto anto wrote:
ku pernah coba coding ini bisa :
Dim sql As String
sql = "select * from Users ORDER BY id"
With ADO
.ConnectionString = "Driver={MySQL ODBC 3.51
Driver};Server= www.freesql. org;Port= 3306;Database= dbobri;User= obri;
Password=emondyhen; Option=3; "
.RecordSource = sql
.Refresh
Set DataGrid1.DataSourc e = ADO
DataGrid1.Columns( 0).Width = 0
End With
tapi kalo mysql di hosting saya sendiri blum bisa kenapa ya...!
--- On Tue, 6/8/10, adi.satya.ms@ gmail.com <adi.satya.ms@ gmail.com>
wrote:
From: adi.satya.ms@ gmail.com <adi.satya.ms@ gmail.com>
Subject: Re: [programmer- vb] cara/coding vb 6 konek dengan database
mysql online...?
To: programmer-vb@ yahoogroups. com
Date: Tuesday, June 8, 2010, 3:35 AM
Begini, untuk koneksi database ke online pake mysql, trus
di odbc ntar diconverter spy vb6 bs baca. Coba digoogling dl trus
diinstall.
Powered by Telkomsel BlackBerry®
From: Awan Darmawan <c_zabr...@rocketmai
l.com>
Sender: programmer-vb@ yahoogroups. com
Date: Tue, 8 Jun 2010 01:26:03 -0700 (PDT)
To: <programmer-vb@ yahoogroups. com>
ReplyTo: programmer-vb@ yahoogroups. com
Subject: Re: [programmer- vb] cara/coding vb 6
konek dengan database mysql online...?
Punteun
Juragan, Ikutan,
Maksud master adi setya (pake converter ODBC mysql gimana ya)
bisa di perjelas gak juragan..
hatur nuhun lah
____________ _________ _________ _________ _________ _________
_________ _________ _______
Awan Darmawan
Chalosa System Computer (chess.com)
Jl Beringin IV No. 8 Perumnas I Parungpanjang
Bogor - Jawa Barat
Indonesia
Phone : 62-95520485
Mobile: 62-85716437319
From:
"adi.satya.ms@ gmail.com" <adi.satya.ms@ gmail.com>
To:
programmer-vb@ yahoogroups. com
Sent: Tue,
June 8, 2010 3:17:20 PM
Subject: Re:
[programmer- vb] cara/coding vb 6 konek dengan database mysql online...?
Pake odbc converter ke mysql.
Powered by Telkomsel BlackBerry®
From: "Erza" <ri_za...@yahoo. com>
Sender: programmer-vb@ yahoogroups. com
Date: Tue, 08 Jun 2010 07:59:38 -0000
To: <programmer-vb@ yahoogroups. com>
ReplyTo: programmer-vb@ yahoogroups. com
Subject: [programmer- vb] cara/coding vb 6 konek
dengan database mysql online...?
To : Para Master VB 6
Mohon Pencerahanya Para master vb semuanya...!
Cara koneksi vb ke database mysql online,
maksutnya aplikasi dekstop tapi database onlline bisa dibuka dimana2...!
