Arsip: Handle error "login database di MySQL"

more 12 years ago
zuq
mohon bantuanya tmen2....
saya pake TSQLConnection di dbExpress untk akses database yg ada d MySQL tp lewat coding......
with SQLConnection1 do
begin
Connected:= False;
ConnectionName := 'MySQLConnection';
DriverName := 'MySQL';
GetDriverFunc := 'getSQLDriverMYSQL';
LibraryName := 'dbexpmysql.dll';
LoadParamsOnConnect := false;
LoginPrompt := false;
params.Values['DriverName'] := 'MySQL';
params.Values['HostName'] := Edit1.Text;
params.Values['Database'] := 'admin';
params.Values['User_Name'] := Edit2.Text;
params.Values['Password='] := Edit3.Text;
params.Values['BlobSize'] := '-1';
params.Values['LocaleCode'] := '0000';
VendorLib := 'libmysql.dll';
Connected := true;
end;
jika host, database, user dan pswd yg d isikan benr maka sukses tp klo sebaliknya maka muncul :
------------------------------------------------------------------------------
project project1.exe raised exception class EDatabaseError with message
'dbExpress Error:Invalid username/Password'............
------------------------------------------------------------------------------
saya mohon bantuny Cara menghandle pesan tersebut, misal d ganti dng "Koneksi Gagal ato yg lebih keren......"

more 12 years ago
donlego
with SQLConnection1 do
begin
try
Connected:= False;
ConnectionName := 'MySQLConnection';
DriverName := 'MySQL';
GetDriverFunc := 'getSQLDriverMYSQL';
LibraryName := 'dbexpmysql.dll';
LoadParamsOnConnect := false;
LoginPrompt := false;
params.Values['DriverName'] := 'MySQL';
params.Values['HostName'] := Edit1.Text;
params.Values['Database'] := 'admin';
params.Values['User_Name'] := Edit2.Text;
params.Values['Password='] := Edit3.Text;
params.Values['BlobSize'] := '-1';
params.Values['LocaleCode'] := '0000';
VendorLib := 'libmysql.dll';
Connected := true;
except
showmessage('koneksi gagal')
end;
end;

more 12 years ago
deLogic
@zuq:
karena Debugger pada IDE Delphi mengambil alih semua eksepsi kesalahan yang terjadi.

more 12 years ago
yayaretina
@zug
benul yg disampaikan rekan @deLogic.
jika tidak menginginkan Debugger Exception Notification aktif,
Pilih Options>Debugger Options>Language Exceptions dan
uncheck pada Stop on Delphi Exceptions.

more 12 years ago
zuq
ok, nih uda aq tmbahi kanan kiri atas dan bawah :D mumpung bisa, ternyata msalahnya d situ ya...., makasih ms dayat, ms delogic & ms yayaretina...
sukses smuaaa...
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
- PascalTalk #5: UX: Research, Design and Engineer
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- mengubah brightness/contrast image greyscale dgn scrollbar
by abu in Tip n Trik Pemrograman more 12 years ago - Menghilangkan Flicker
by tendafahmi in Tip n Trik Pemrograman more 11 years ago - Tny ttg Time ????
by camp_sire in Tip n Trik Pemrograman more 12 years ago - koneksi ke foxpro
by idhiel in Tutorial & Community Project more 8 years ago - update tanggal otomatis menggunakan MSAccess
by divanda in MySQL more 13 years ago - Skin delphi
by DikDod in Tip n Trik Pemrograman more 13 years ago - Form dalam Aplikasi MDI
by rho in Form Enhancement & Graphical Controls more 13 years ago - [ask]Random gambar
by laguna in Hal umum tentang Pascal Indonesia more 14 years ago - cek printer hiDup/mati
by ImanD in Tip n Trik Pemrograman more 14 years ago - SMS dari PC ke HP dan dari HP ke PC
by kacungdelphi24 in Tip n Trik Pemrograman more 12 years ago