/build/static/layout/Breadcrumb_cap_w.png

Connecting to the Kace Database via ODBC/Filemaker/Mac

Has anyone using a Mac had success using a 3rd party tool (like Filemaker) to connect to the K1000 Database to run reports? If so, how did you do it? 

I'm trying to connect to K1000 database via Filemaker, so I can run reports using it. I'm on a Mac. I followed instructions for Kace (http://www.kace.com/support/resources/kb/solutiondetail?sol=114992) and for Filemaker (http://www.filemaker.com/help/13/fmp/en/html/odbc_ess.20.2.html#1027549) . No luck. 

I opened port 3306 via TCP and enabled database access in the Kace environment. I also installed a MYSQL driver from the MYSQL website. 

Any help is appreciated. 

 


4 Comments   [ + ] Show comments
  • Are you able to connect using MySQL Workbench or other tools? - MacDude 6 years ago
  • What other tools can I use to test this out? - ems296 6 years ago
  • MYSQL Workbench did not work. I did verify via terminal my computer can connect to the SQL database. However, I can't connect through My Workbench. I noticed the instructions I was given are for Windows. Do they differ for Macs?

    http://www.kace.com/support/resources/kb/solutiondetail?sol=114992 - ems296 6 years ago
  • Nevermind. It just worked for me! - ems296 6 years ago

Answers (1)

Answer Summary:
Posted by: MacDude 6 years ago
Fifth Degree Brown Belt
0
solved. (not sure what changed).
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ