I changed odbc from CoffeePot to NorthWind (MSSQL 7.0)
I have DSN under System and can access it from PowerBuilder so it works.
This is the error i get when i run .jsp
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor
Index
----- Original Message -----
From: Matthews,Paul <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 12:45 PM
Subject: Re: DB Access problem
> silly question- should that be 'CoffeePot' in the url?
>
> also call getConnection(url); rather than passing empty username/password
>
> regards, paul
>
> > -----Original Message-----
> > From: Tarik Makota [mailto:[EMAIL PROTECTED]]
> > Sent: 09 August 2000 17:37
> > To: [EMAIL PROTECTED]
> > Subject: DB Access problem
> >
> >
> > This is my acctual bean that is supposetly to connect to DB:
> > I put the 'markers' so that i know where it stops.
> >
> > As soon as it hits Connection conn = ... it stops
> > because in my jsp page print the propert userName
> > so that i know wher do i get stuck.
> > JSP page is displayed without any errors
> >
> >
> > My DSN is ok because i have tried User and System.
> >
> >
> >
> > ----------------------------------------------------------
> > package foo;
> > import java.util.*;
> > import java.sql.*;
> > import java.net.URL.*;
> >
> >
> > public class DBLoginBean6{
> > private boolean isValid = false;
> > private String userName;
> > private String userPassword;
> >
> > public DBLoginBean6() {
> > userName="Initalized";
> > userPassword="";
> > String url = "jdbc:odbc:CofeePot";
> > String query = "SELECT * FROM EMPLOYEES";
> > String firstName;
> > String lastName;
> > boolean more;
> > try
> > {
> > userName="First Try";
> > try{
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > }
> > catch (java.lang.ClassNotFoundException ex)
> > {
> > ex.printStackTrace();
> > }
> > userName=" connection begin";
> > Connection con = DriverManager.getConnection(url,"","");
> > userName="I connected";
> > Statement stmt = con.createStatement();
> > userName="i created statement";
> > ResultSet rs = stmt.executeQuery(query);
> > userName="i executed statement";
> > while (more = rs.next())
> > {
> > firstName = rs.getString("FIRSTNAME");
> > lastName = rs.getString("LASTNAME");
> > System.out.println( firstName + " " + lastName);
> > userName = "I was executed";
> > }
> > userName="I did while";
> > rs.close();
> > stmt.close();
> > con.close();
> > userName="And i ewxited";
> > }
> > catch (SQLException ex)
> > {
> > ex.printStackTrace();
> > }
> >
> >
> >
> > }
> >
> > public String getuserName() {
> > return userName;
> > }
> > public String getuserPassword() {
> > return "I am user Password";
> > }
> >
> > }
> > ----------------------------
> >
> > ==============================================================
> > =============
> > To unsubscribe: mailto [EMAIL PROTECTED] with body:
> > "signoff JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
