Thursday, November 10, 2011

Old School JDBC-ODBC

I think I did this once 12 years ago but today I wanted to test the accessibility of a SQL Server 6.5 database. After creating a ODBC datasource in Windows for the remote database, the following code ran perfectly. Recall that the JdbcOdbcServer.class is included in rt.jar so it is available without listing any jar in the classpath.

This proved to me that the database was not the issue causing the Windows 95 application to fail.