Originally posted by Tom Blough:
Todd,
Did you set up idxAnalyzerCustom as a user or system data source? If you use that form you need to configure an ODBC datasouce on your machine with that name. For MS Access you can use the alternative URL for the getConnection method that specifies the file/path to the .mdb file that I wrote about.
Java is also case sensitive. sun.jdbc.odbc.JdbcOdbcDriver is not the same as sun.jdbc.odbc.jdbcodbcdriver. The former is correct.
Tom
Damn! That must be it then...
I did: "sun.jdbc.odbc.jdbcodbcdriver"
Yeah, I already have an ODBC set up with that exact name. "idxCustomAnalyzer".
Thanks everyone for all the help, I really appreciate it.
I'm used to Delphi and Visual Basic, neither of which care very much for the case of the variables and whatnot.
This is very similar to Mumps with respect to case sensitivity.
Thanks!!!