Connection with database...

Hi All,

I want to retreive records from database but i have one problm in the below Code where should i pass my Server name and Database name..because my data is on server not on my local database..in below code "Data" is my database name and "Cust" is my tablename..

Pls help.....

<%@ page import="java.sql.*" %>

<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

<HTML>
<HEAD>
<TITLE>Selecting tableName From a Database</TITLE>
</HEAD>

<BODY>
<H1>Selecting tableName From a Database</H1>

<%
Connection connection = DriverManager.getConnection(
"jdbc

dbc:data", "userName", "password");

Statement statement = connection.createStatement() ;
ResultSet resultset =
statement.executeQuery("select * from cust where city = 'Boston'") ;
%>

<TABLE BORDER="1">
<TR>
<TH>ID</TH>
<TH>Name</TH>
<TH>City</TH>
<TH>State</TH>
<TH>Country</TH>
</TR>
<% while(resultset.next()){ %><TR>
<TD> <%= resultset.getString(1) %></td>
<TD> <%= resultset.getString(2) %></TD>
<TD> <%= resultset.getString(3) %></TD>
<TD> <%= resultset.getString(4) %></TD>
<TD> <%= resultset.getString(5) %></TD>
</TR>
<% } %>
</TABLE>
</BODY>
</HTML>

Thanks & Regards,
Yunus

Originally posted by yunuss khan:

Connection connection = DriverManager.getConnection("jdbc:odbc:data","userName", "password");

hi yunus,

A database on a remote server requires more information, however. If the database is to be accessed over the Internet, for example, the network address should be included in the JDBC URL as part of the parameter.

[ December 08, 2006: Message edited by: Saif uddin ]