returning path of database from a connection 1

[msloan]

I have a user defined System DSN on the client machine. From there the user will specify the name of that DSN in my app. Is there any way to retrieve the path of the database that that DSN points to?

TIA

 

[JVZ]

Can you try something like this, and let me know your results...(I can not test it out..currently).

DatabaseMetaData dbMetaData = aConnection.getMetaData();
ResultSet rs = dbMetaData.getTables(null,null, null, null);
System.out.println(rs.getString(1));

 

[msloan]

after adding a try/catch block and calling rs.next(), worked great!!!

Thanks for the help!