Cannot connect to MySQL Database

[lion_kg]

I am trying to setup database connection to MySQL server using MySQL ODBC driver that i downloaded from mysql web site. What should I put into "Data source". When I leave it blank I get an error "Data source name not found and no default driver specified". In "Driver" I choose MySQL ODBC 5.2w Driver. Provider is set to MySQL (MSDASQL). The only option that gives me successful connection is dBase Files, but in this case Database Manager shows no data, although there is data in the database, and I see no connection attempts using tcpdump on the server where mysql DB server resides.

[Fiery]

For MySQL you need to select the MySQL ODBC driver in the Driver drop-down list, enter your Database name, enter your Server address (hostname or IP address), and enter your credentials (User + Password).  If you fill in all those fields, you can leave the Data source field empty.

 

Regards,

Fiery

[TerAnYu]

Hello!
Whether it is planned to use in AIDA64 Business Edition MySQL Connection not through ODBC, and through the only library (C ++ Driver for MySQL (Connector/C ++) or C Driver for MySQL (Connector/C))?
To use ODBC on each personal computer in the domain - it isn't really good, in view of excess and unnecessary libraries when it is possible to use only one.

[Fiery]

I'm afraid you need to install the MySQL Connector/ODBC on every client computers, to make it work with AIDA64.

Regards,

Fiery

[TerAnYu]

It is a pity.
Alas, I don't know programming languages, but some projects use the only dynamic library libmysql.dll, and the settings are specified in the project.
There is a nuance that libmysql.dll has to be the same version as the server, but it is a smaller problem, than to establish on each MySQL Connector/ODBC personal computer.

I ask to excuse if something not so, I want to make your program more universal and simple.

[Fiery]

Yes, we aware of the fact that it would be possible to implement native support for certain database servers, but as you pointed out, it's not a generic solution that could be future-proof or "fool-proof"

[TerAnYu]

Thanks for the answer.
I hope nevertheless for emergence of such functionality, even in test and unstable realization though the probability is small.

[Percy]

Good morning, I wrote everything according to the video 

,

but my server does not run any report, I havent database access only. I put this on the parameters /R /CSV /AUDIT /SAFE Help me with that, thank you.

[Fiery]

I put this on the parameters /R /CSV /AUDIT /SAFE Help me with that, thank you.

In case you want to push your reports into a SQL database, then you need to remove /CSV from your command-line, and add /DATABASE instead.