Hi,

here is a snippet of a jsp page I built just for fun to test java?!? and SQL Server.

www_assetlist is a view on the SQL Server.

<%

String lpszSQL;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch (ClassNotFoundException e)

{

out.println("<h1>Driver not found:" + e + e.getMessage() + "</h1>" );

}

try

{

Connection conn = DriverManager.getConnection ("jdbc:odbc:sqlprost");

Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

ResultSet rs;

if (request.getParameter("Assets")==null)

{

lpszSQL = "www_assetlist '%'";

}

else

{

lpszSQL = "www_assetlist '"+request.getParameter("Assets")+"'";

}

rs = stmt.executeQuery(lpszSQL);

%>

<table>

<tr>

<td>

<font class = "frank">

<b>

Ka-Nr

</b>

</font>

</td>

<td>

<font class="frank">

<b>

WKN

</b>

</font>

</td>

<td>

<font class="frank">

<b>

Bezeichnung

</b>

</font>

</td>

<td>

<font class="frank">

<b>

Klasse

</b>

</font>

</td>

</tr>

<%

while ( rs.next() )

{

String kanr = rs.getString("Ka-Nr");

String wkn = rs.getString("WKN");

String bez = rs.getString("Kapitalanlagenbezeichnung");

String klasse = rs.getString("Risikoklasse");

%>

<tr>

<td>

<font class="frank">

<%

out.println(kanr);

%>

</font>

</td>

<td>

<font class="frank">

<%

out.println(wkn);

%>

</font>

</td>

<td>

<font class="frank">

<%

out.println(bez);

%>

</font>

</td>

<td>

<font class="frank">

<%

out.println(klasse);

%>

</font>

</td>

</tr>

<%

}

out.println( "</table>" );

conn.close();

} catch (Exception e)

{

out.println( "<h1>exception: "+e+e.getMessage()+"</h1>" );

}

%>

It works just fine.

Maybe it helps?

Cheers,

Frank