When working with JDBC we create DSN in windows but when uploading the webapp then how shall the server know about my database and how the servlets know that where the database is present since we point to database through the DSN shall we create DSN there too or there is some other way out.
So you are currently using the jdbc-odbc bridge right? You will have better performance if you use a driver that is specific for your db. Then you don't have to worry about creating DSNs (ODBC data sources) on the client/server. Once you have your driver, you have to register it just like you do with the jdbc-odbc bridge driver. For more info on registering the driver you should be able to search this forum. Also, for a basic tutorial on JDBC, check out this Hope that helps
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"
"kamran", Thanks for participating here at the Ranch. However, the name you are using does not comply with our naming convention described at http://www.javaranch.com/name.jsp . Please log in with a new name, which meets these requirements. You can change your name here. Thanks. Sean
subject: jsp hosting with database problem please help