我用的無驅動連接的兩個dll,libmysql.dll和dbxopenmysql50.dll
with simpledataset1.Connection do
begin
try
Close;
GetDriverFunc := 'getSQLDriverMYSQL50';
LibraryName := 'dbxopenmysql50.dll';
VendorLib := 'LIBMYSQL.dll';
DriverName:= 'dbxmysql';
Params.Values['drivername']:= 'MySQL';
Params.Values['port'] := '3306';
Params.Values['hostname'] := '127.0.0.1';
Params.Values['database'] := 'root';
Params.Values['user_name'] :='root';
Params.Values['password'] := '123';
form1.SimpleDataSet1.Active:=false;
form1.SimpleDataSet1.DataSet.CommandText:=' select * from user where username=:username';
form1.SimpleDataSet1.DataSet.ParamByName('username').Asstring:=username;
form1.SimpleDataSet1.Active:=true;
form1.SimpleDataSet1.Edit;
password:=form1.SimpleDataSet1.FieldByName('password').Asstring;
except on E: Exception do
raise Exception.Create('資料庫連接錯誤：'+E.Message);
end;
end;
錯誤提示入題
uj5u.com熱心網友回復：
連接mySql有兩個DLL,除了你這個，還有一個是libMysql51.dlluj5u.com熱心網友回復：
libmysql.dll的版本對嗎轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/11170.html
標籤：數據庫相關
上一篇：delphi 如何用reportbulider做報表，完全不會
下一篇：遍歷Windows桌面上所有視窗