老掉牙的问题了,delphi怎么连接mysql? ( 积分: 100 )

最好是编译后客户能直接用的,不用配置ODBC这些的<br>用什么办法比较好,<br>另找下<br>谁有MySQLDAC控件破解版啊?<br>因为这个控件确实相当好用<br><br>delphi连接mysql的最好提供个例子,(不用配置ODBC的)

用ADO连接<br><br>ADOConnection1.ConnectionString&nbsp;:=&nbsp;'Provider=SQLOLEDB.1;Password=ABC;Persist&nbsp;Security&nbsp;Info=True;User&nbsp;ID=sa;Initial&nbsp;Catalog=&nbsp;MySqlServer;Data&nbsp;Source=127.0.0.1';<br>Try<br>&nbsp;&nbsp;ADOConnection1.Open;<br>Except<br>&nbsp;&nbsp;MessageBox(Longint(DM),&nbsp;PChar('连接数据库服务器出错!'),&nbsp;'数据库连接',&nbsp;MB_ICONERROR);<br>Exit;

楼上的看清楚，是连接mysql,

如果用的&nbsp;Delphi2007则可用DBX驱动来连接&nbsp;MySQL&nbsp;。<br>手头没有&nbsp;Delphi&nbsp;不能帮你写连接方式了。<br>很简单的。

盒子里有现成的mydac，支持BDS2006，下载地址：<br>http://www.2ccc.com/article.asp?articleid=4280

下个驱动mysql&nbsp;odbc3.5<br>建立数据原<br>然后在delphi里面的连接不要第二次输入密码（如有用户名和密码），也不要选择具体的数据库就行了

好像必须得用ODBC

用SQLDirect吧,不用设ODBC,只需到MYSQL的BIN目录拷一个libmysql.dll到windows系统目录或运行目录就可以了.连接方法:<br>&nbsp;&nbsp;with&nbsp;SDDatabase&nbsp;do&nbsp;<br>&nbsp;&nbsp;begin<br>&nbsp;&nbsp;&nbsp;&nbsp;close;<br>&nbsp;&nbsp;&nbsp;&nbsp;ServerType&nbsp;:=&nbsp;stMySQL;<br>&nbsp;&nbsp;&nbsp;&nbsp;RemoteDatabase&nbsp;:=&nbsp;'127.0.0.1:mydb';<br>&nbsp;&nbsp;&nbsp;&nbsp;Params.Values['USER&nbsp;NAME']&nbsp;:=&nbsp;'root';<br>&nbsp;&nbsp;&nbsp;&nbsp;Params.Values['PASSWORD']&nbsp;:=&nbsp;'root';<br>&nbsp;&nbsp;&nbsp;&nbsp;open;<br>&nbsp;&nbsp;end;<br><br>显示不了中文时,连接数据库后,用SDQuery&nbsp;发送一次命令:set&nbsp;character&nbsp;set&nbsp;gbk&nbsp;就可以了.

用mydac

function&nbsp;SQLConfigDataSource(hwndParent:&nbsp;Integer;&nbsp;fRequest:&nbsp;Integer;lpszDriverString:&nbsp;String;&nbsp;lpszAttributes:&nbsp;String):Integer;stdcall;external'ODBCcp32.DLL';<br>&nbsp;<br><br>&nbsp;reg:=tregistry.create;<br>&nbsp;reg.rootkey:=hkey_local_machine;<br>&nbsp;<br>&nbsp;if&nbsp;not&nbsp;reg.OpenKey('SOFTWARE/ODBC/ODBC.INI/ODBC源名',false)&nbsp;then<br>&nbsp;&nbsp;begin<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQLConfigDataSource(0,&nbsp;4,'SQL&nbsp;Server',<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'DSN=ODBC源名'+&nbsp;chr(0)+<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Server=服务器名'+&nbsp;chr(0)&nbsp;+<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Trusted_Connection=Yes'+&nbsp;chr(0)&nbsp;+<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Database=数据库名'+&nbsp;chr(0));<br>&nbsp;&nbsp;end;

用zeoslib&nbsp;吧,简单方便,比楼上的都好