MaestroS
User
Fresh Boarder
| Posts: 7 |   |
Karma: 0
|
|
Re:Getting databases
|
|
Posted: 2007/08/07 07:34 |
|
|
|
|
But look.
With this code
try
adquery1.Close;
adquery1.sql.clear;
adquery1.ObjectView := true;
adquery1.SQL.Add('SHOW DATABASES;');
adquery1.open;
while adquery1.Eof do begin
allistbox1.items.Add(adquery1.fieldbyname('Database').asstring);
adquery1.Next;
end;
except
allistbox4.Items.add('Error while receiving databases...');
end;
|
And this settings:
//adconnection1.Params.Add('Database='+aledit4.text);
adconnection1.Params.Add('User_Name='+aledit2.text);
adconnection1.Params.Add('Password='+aledit3.text);
adconnection1.Params.Add('Host='+aledit1.text);
adconnection1.Connected := true;
|
It doesn't work...
No errors occur during connecting and executing "SHOW DATABASES;", but also no databases are displayed in ALListbox1
It works only when I use DBGrid, but I want to do it with ALListbox :/
What's going on ?
Post edited by: MaestroS, at: 2007/08/07 07:37
|
|
