Hi
I'm having real problems trying to read in data from an excel spreadsheet.
I created an ODBC system DSN pointing to my spreadsheet on the MII server, called myDSN.
I then created a new IDBC data server with the following settings
JDBCDriver : sun.jdbc.odbc.JdbcOdbcDriver
ServerURL : jdbc:odbc:myDSN
Username, password and validation query I've left blank.
When I try to use this server I get an error message "Cannot create a connection to the database".
Any ideas?