請問如何在符合下列情況之下，以 delphi 連接到 mysql 1.mysql 裝在另外一台電腦的server 2.使用 TSQLConnection 已經將libmysql.dll和其他必要檔案弄好了，但是就是會發生「錯誤密碼」的訊息，而確定密碼沒有問題。怎麼會這樣呢？

------
有困難就是能力不足，有麻煩就是方法不對... 劣者總是遇到困難，也時常出現麻煩

密碼不可為空....... @@~~飛翔在天際的精靈~~@@

------
@@~~飛翔在天際的精靈~~@@

請問什麼是 TSQLConnection , 我的 D5 找不到這個 VCL. libmysql.dll 又是做何用途 ? 另外想請問:MySql 可以透過 ADO 存取嗎? 先謝謝各位的回答.

引言: 請問什麼是 TSQLConnection , 我的 D5 找不到這個 VCL. libmysql.dll 又是做何用途 ? 另外想請問:MySql 可以透過 ADO 存取嗎? 先謝謝各位的回答.

經過一段時間，吾已經將此部份弄了解了。沒辦法，做專題不得不如此。 TSQLConnection是在dbExpress裡面的，和ADO無關。另外，mysql應該不可能用ADO存取。要存取mysql目前除了odbc之類的方法之外，最直接的就是用dbExpress的TSQLConnection掛上驅動程式。

I have use ADO connect to My-SQl.it's ok to do ..I Try about 2 hours..I think Let's find out Your problem first.. What Os at MySql install ? Do You download new MySql-ODBC ? Do You setup ok at My-Sql Username Password(You can check many Linux information about that..) and make sure dont empty at your password Check your computer ODBC test connect Ok!!

轉載 News 上面的: -- I get error "DBExpress errror: Invalid Username/Password" when trying to connect a TSQLConnection locally or via LAN, to a working MySql 3 or MySql 4 server. If I connect with other programs (winmysqladmin.exe, MySqlManager.exe, mysqlfront.exe) it works fine. I have tried with dbexpmy4.dll and dbexpmysql.dll to no avail. I'm confident that my my.ini and user names are correct, mainly because several other tools and php-forums can run on the MySql server without any problems. Could there be some problem with passing username and passwords from dbexpress to mysql? I have just sucessfully tested dbexpress with interbase/firebird with no connection problems. How can I get to the root of the problem? Thomas -- After downgrading to 3.23.52 I could connect without problems. I then use dbexpmysql.dll. Has anybody had success with dbexpmy4.dll ? I'd like to know the version number for the various components of a working MySql 4: dbexpmy4.dll ? LIBMYSQL.dll ? Thomas -- I found that the mysql 4 install didn't overwrite the libmysql.dll from my mysql 3.23 install. I had to manually copy the libmysql.dll from the mysql\bin directory. It does work. -- I tried again, copying the file, but still it does not work. Can you tell me where you got your copy of dbexpmy4.dll ? (tell exactly where...) Thomas -- http://codecentral.borland.com/codecentral/ccweb.exe/listing?id=17739 -- 發表人 - paikang 於 2002/10/15 10:32:31

------
我的簽名~
http://www.watermonster.org/phpBB/index.php

後來發現，的確是版本的問題。 我的狀況是利用四版的client驅動程式要去連三版的伺服器。 本來是想說，比較新版比較好說。

------
有困難就是能力不足，有麻煩就是方法不對... 劣者總是遇到困難，也時常出現麻煩