Jump to content
AIDA64 Discussion Forum
lion_kg

Cannot connect to MySQL Database

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Regards,

Fiery

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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" :(

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×