I'm trying to establish a connection to mySql database from within a Java class I'm developing. The Java statement I'm using is in the format of: Connection con = DriverManager.getConnection(fileURL, userName, passWord); My question is: What fileURL should I use to connect to my database (it's on the rumpus server)?
Can't believe I missed it! Of course, the fileURL is whatever name I used to register the database with the ODBC Data Source Administrator! Providing the db is configured correctly with the mySQL ODBC driver and this picks up the rumpus.plus.net server, the connection should work. ... and it does! Thanks to Richard G. Baldwin and his article for pointing me in the right direction: http://www.developer.com/java/data/article.php/3417381