I am attempting to write a small java application that does a lookup in a SQL Server db and allows the user to view and update the data. This is an application this getting called from another application, and so I am limited to what data they can pass to me. They wish to use a DSN name to identify the database. So that means I need to use the wonderful JDBC-ODBC bridge to connect to the DSN database. That throws all kinds of errors when I attempt to update the data back to the database.
"Optional feature not implemented".....etc.
I know this is a limitation of the JDBC-ODBC bridge driver that is being used. I would like to use the standard SQLServer jdbc driver, but I don't know any of the DB parameters other than DSN name. I would like to know if there is a way that I can somehow lookup the information in the DSN connection and not use the ODBC bridge. Any ideas?