Email Subscription Notifications Suspended Temporarily
We are in the process of making navigation in the Servers and Operating Systems forums simpler and more direct. While doing this, we have to temporarily suspend email notifications for subscriptions. If you are subscribed to one or more discussion boards or blogs in the community, please check them daily to see new content. Notifications will be turned back on in a few days. We apologize for any inconvenience this may cause. Thanks, Warren_Admin
Switches, Hubs, and Modems
cancel
Showing results for 
Search instead for 
Did you mean: 

Access to dbase from external app

Jason Scott
Regular Advisor

Access to dbase from external app

Sorry, another dbase question. I can successfully access the PNM database with the mySql query browser tool but I'm having difficulty connecting from another SQL server.

The SQL server wants to know a datasource name, which isn't needed with the mySql browser. I'm also unsure if this method would work anyway.

My ultimate goal is to make a live connection between the SQL and PCM server to pull the switch data every week and update our asset database. Any help greatly appreciated.
2 REPLIES
Jason Scott
Regular Advisor

Re: Access to dbase from external app

I have solved this.

To make the connection I had to install the mySQL ODBC driver. When configuring this connection it links to the database and pulls down a list of two schemas:

netmgmt
information_schema

The netmgmt one contains the tables with all the switch data in. Just remember when configuring the ODBC connection to change the port to 3908.
Jason Scott
Regular Advisor

Re: Access to dbase from external app

See above.