ODBC - MYSQL
Where can I find idiot-proof instructions on connecting to the Kbox with MySQL Workbench? Any help is appreciated!
0 Comments
[ + ] Show comments
Answers (6)
Please log in to answer
Posted by:
cblake
12 years ago
http://www.kace.com/support/kb/index.php?action=artikel&cat=9&id=9&artlang=en
Nothing is idiot-proof; I always find a way to break something :)
One thing I've found is sometimes you need to reboot your workstation after you install all of the ODBC drivers and whatnot.
Nothing is idiot-proof; I always find a way to break something :)
One thing I've found is sometimes you need to reboot your workstation after you install all of the ODBC drivers and whatnot.
Posted by:
jgro
12 years ago
Thanks. That is the article I was looking at but even after multiple attempts and reboots, I can't seem to get the MySQL 3.51 driver to show up in the ODBC Data Source Administrator window.
I have a K1000 running 5.3.45497
I have a K1000 running 5.3.45497
Posted by:
cblake
12 years ago
That article may be a bit dated, especially if you're running a Win7 or x64 station.
Try the newer connectors at http://dev.mysql.com/downloads/connector/odbc/ and let us know if you have better results.
I've also heard good things about FlySpeed (after the MYSQL ODBC Connection is established.) http://www.activedbsoft.com/overview-querytool.html
I haven't used it personally, but I've seen positive things.
Try the newer connectors at http://dev.mysql.com/downloads/connector/odbc/ and let us know if you have better results.
I've also heard good things about FlySpeed (after the MYSQL ODBC Connection is established.) http://www.activedbsoft.com/overview-querytool.html
I haven't used it personally, but I've seen positive things.
Posted by:
jgro
12 years ago
Thanks. That gets me the ability to add the ODBC connection, but the test still fails everytime. Do I need to turn on database access in the settings or do anything else? I've checked the database name & report username, and ever reset the password for "R1" on the Kbox to make sure it is what i'm typing for the ODBC connection...
Posted by:
cblake
12 years ago
Yes, Database access option in Settings--> Control Panel--> Security is required. It's on by default and I made an assumption it wasn't off; sorry.
Posted by:
snissen
12 years ago
Also, if you're in an organization where you don't control the network infrastructure (firewalls, routers, and the like), you might need your network administrator to open the MySQL port(s) between your client machine(s) and the server. Sande
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.