lion_kg Posted April 3, 2013 Share Posted April 3, 2013 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. Quote Link to comment Share on other sites More sharing options...
Fiery Posted April 3, 2013 Share Posted April 3, 2013 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 Quote Link to comment Share on other sites More sharing options...
TerAnYu Posted March 7, 2015 Share Posted March 7, 2015 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. Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 7, 2015 Share Posted March 7, 2015 I'm afraid you need to install the MySQL Connector/ODBC on every client computers, to make it work with AIDA64. Regards, Fiery Quote Link to comment Share on other sites More sharing options...
TerAnYu Posted March 10, 2015 Share Posted March 10, 2015 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. Quote Link to comment Share on other sites More sharing options...
Fiery Posted March 10, 2015 Share Posted March 10, 2015 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" Quote Link to comment Share on other sites More sharing options...
TerAnYu Posted March 11, 2015 Share Posted March 11, 2015 Thanks for the answer.I hope nevertheless for emergence of such functionality, even in test and unstable realization though the probability is small. Quote Link to comment Share on other sites More sharing options...
Percy Posted May 29, 2015 Share Posted May 29, 2015 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. Quote Link to comment Share on other sites More sharing options...
Fiery Posted May 30, 2015 Share Posted May 30, 2015 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.