|
hello guys im having slight diffuclity with viweing my jsp page.
i am creating a search for mobile phones where users can enter in names of fucntions and can see results
i have got this error:
Exception=java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
i have created a user dns and have specfied teh name of this
jsp code is:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.3//EN"
"http://www.wapforum.org/DTD/wml13.dtd">
<%@ page import="java.sql.*"%>
<%@ page language="java" contentType="text/vnd.wap.wml"%>
<wml>
<template>
<do type="prev">
<prev/>
</do>
</template>
<card id="results_searched" title="Results">
<p>
<%
String Search;
Search=(String)request.getParameter("srch");
try
{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection ("jdbc:odbc:Search");
Statement stat = con.createStatement();
ResultSet res = stat.executeQuery("select Functions from MsgTble,CalTble,ExtraTble,AppTble,bluetthTble,calcTble,CallRegTble,GamesTble,ProfileTble,ServcieTble,SettingsTble,TodoTble WHERE Name LIKE '%"+Search+"%'");
while(res.next()){
Search= res.getString ("Functions");
out.println(Search+" ");
}
res.close();
}
catch(Exception e)
{
out.println("Exception="+e);
}
%>
</p>
</card>
</wml>
please could someone help me out as to where i have gone worng or what i can do! this is for a project so really need to know
thank you soo much
|
|
|
|
|
|
|
|