'm trying to make an ODBC connection in Java through Windows ODBC Manager. I have managed to read the registry to get a listing of System DSNs and once a selection is made by the user I read the "HostMachine" parameter in the registry associated with the selected SystemDSN and from there I want to make that ODBC connection. I have tried the DriverManager getConnection method but it doesn't seem to work! Any ideas PLZ??!
Please note that I want to access the servers through their associated IP addresses and less likely urls, hence (HostMachine)!
Also each of these System DSNs are associated with a driver that would need to be used to connect its related data source!