aspose file tools*
The moose likes JDBC and the fly likes how to connect databas using odbc in servlet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to connect databas using odbc in servlet " Watch "how to connect databas using odbc in servlet " New topic
Author

how to connect databas using odbc in servlet

bhavishya goyal
Greenhorn

Joined: Sep 26, 2008
Posts: 1
i m creating simple page and codding of my class is bellow . tell me how i can connect database at running time .i m using ms access as when



i start server and enter user name and password .there is processing but it does not make any respond . tell me what is the problem help me [email removed]
[ September 26, 2008: Message edited by: Bear Bibeault ]
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 40052
    
  28
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to connect databas using odbc in servlet