how can I use UniConnection1 to connect to mysql with out database's name?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
wylton
Posts: 1
Joined: Sun 28 Oct 2012 22:11

how can I use UniConnection1 to connect to mysql with out database's name?

Post by wylton » Sun 28 Oct 2012 22:22

I can use zeoslib like this:
ZConnection1.HostName:=ServidorEdit.Text;
ZConnection1.User:=useredit.Text;
ZConnection1.Password:=PasswdEdit.Text;
ZConnection1.Port:=StrToInt(PortEdit.Text);
ZConnection1.Protocol:='mysql-5';
try
ZConnection1.Connect;

except
begin
ShowMessage('error'); exit; end;
end;

to test connection..

but , I can't do same with UniConnection1. can you help me?

with this:
UniConnection1.LoginPrompt:=False;
UniConnection1.Server:=ServidorEdit.Text;
UniConnection1.ProviderName:='mysql';
UniConnection1.Port:=StrToInt(PortEdit.Text);
UniConnection1.Username:=useredit.Text;
UniConnection1.Password:=PasswdEdit.Text;
try
UniConnection1.Connect;
except
begin
ShowMessage('error'); exit; end;
end;

always askme a database's name..

AndreyZ

Re: how can I use UniConnection1 to connect to mysql with out database's name?

Post by AndreyZ » Mon 29 Oct 2012 08:04

Hello,

You can connect to MySQL using UniDAC without specifying the database name. Please specify the exact error that occurs on executing the UniConnection1.Connect method.

Post Reply