Welcome to JavaRanch
Please go back and edit your post (pencil-and-paper icon) so as to disable smilies and get rid of the excess spaces round the : and o which appear as
.
Please don't ask people to e-mail you.
What are you supposed to pass to the
JDBC connection? Is it really "Jdbc: odbc:user" not the user's name? How are you passing a user name and password to the database?
You appear to be calling rs.next() frequently; you call
if (rs.next()) which will go to the first row of the ResultSet, then
while (rs.next()) which will start from the 2nd row. I think the if is unnecessary, and might cause you to miss the 1st row.
See whether my suggestions are any help; if not, please ask again.
[ September 26, 2008: Message edited by: Campbell Ritchie ]