Using ODBC to connect MYSQL, but the disadvantage is that need to be on the client computer set up ODBC, so that customers more troublesome,
If I use ADO connection, I just write the connection string in the program.

CodePudding user response:

How do you write this connection string

CodePudding user response:

It is recommended to use mydac, functions are all the actions by the other party,

CodePudding user response:

To install MySQL ADO drive.

CodePudding user response:

I still consider using a third party controls, this to the customer, don't need the customer to configure ODBC, convenient,

Third party controls have MYDAC zeoslib, DAC for MySQL, AnyDAC,
What a good point!

CodePudding user response:

Just use ado directly, configure what ODBC,

CodePudding user response:

I've DEPHI connection is SQL SERVER directly ADO, don't need to configure the ODBC and what database connection software installation,
But the MYSQL can also use, specific I need how to write, the connection string

I tried several connection string concatenation,
Driver={XXXXXXXX}; Server=127.0.0.1; The Database=world; User=root; Password=a123; Option=3;

In addition if want to install a database connection using ADO is software,

CodePudding user response:

I now use ADO connection program is essentially a database, don't need to configure the ODBC and third party controls,

Best I connect MYSQL can also so,

CodePudding user response:

http://www.devart.com/unidac/
This is so that

CodePudding user response:

To share my experience of ADO connection MYSQL

First of all to MYSQL website to download the ODBC connection driver, install
Then write ADOConnection in program control of the connection string as follows
'the Provider=MSDASQL. 1; Password=1234; Mode=ReadWrite. Extended Properties="DRIVER={5.2 ANSI MySQL ODBC DRIVER}; The PWD=1234; Server=127.0.0.1; The database=DB1; User=root; Option=3;" ';

So you need not every computer configuration ODBC, but still need to install MYSQL ODBC driver on the computer

CodePudding user response:

Need to install mysql odbc can best image manipulation,

CodePudding user response:

Recommend you use ODBC, advantages: very stable,
If they are to connect directly with MYDAC controls, but may be a little small problems, I use both, the pursuit of stability in the ODBC way,

CodePudding user response:

I also use MYDAC before, but have been concerned about this control is not stable, ODBC and trouble you need to set up the ODBC data source, hope have a good solution,

CodePudding user response:

Need to download mysql driver, and then create a new ODBC data source, the rest is adoconnection adoquery, set up the data source, as the other operations

CodePudding user response:

Download a MySQL. Pas, release the corresponding version of libmysql. DLL packaging together, fix,

http://www.audio-data.de/mysql.html

CodePudding user response:

www.devart.com have all about database development controls products,
Udac msdac, mydac...
Problems in May not didn't find the answer?
Knot rate is too low,

CodePudding user response:

Suggest using undac, super easy to use,