Switches, Hubs, and Modems
1748252 Members
3864 Online
108760 Solutions
New Discussion юеВ

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 2
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.