How to connect to a remote MySQL server using an ADO connection?

[apostolchopov]

Hi, guys!
I would like to know how to connect to a remote MySQL server using an ADO connection object, for example from Delphi. Could you send me some examples, please?!
Thank you very much in advance!

 

[Bastien]

'vb example

PortalStDB = "DRIVER={MySQL ODBC 3.51 Driver};" &_
             "SERVER=111.222.255.255;" &_ 
             "Port=3306;" &_
             "DATABASE=mydb;" &_
             "UID=my_user;" &_
             "PWD=my_pass;"

Bastien

Cat, the other other white meat