Msaccess and iplanet

[shankar]

Hi everyone
    I am using iplanet webserver.I tryed to connect with msaccess
database via servlet.The driver i am using is
"sun.jdbc.odbc.JdbcOdbcDriver".This is setting  successfully running in
jsdk2.1 server. But this setting is not running in iplanet webserver.

The following code is i'm using.....


try
  {
out = res.getOutputStream();
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   connection = DriverManager.getConnection("Jdbc:Odbc:Online");
   stmt = connection.createStatement();

  }
  catch(ClassNotFoundException classExp)
  {
   System.out.println(classExp);
  }
  catch(SQLException sqle)
  {
  }
  catch(IOException ioe)
  {
  }

function()
{
.........................
pstmt= connection.prepareStatement("Insert into Customer
values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
   pstmt.setString(1,Str1);
   pstmt.setString(2,Str2);
  pstmt.setString(3,Str3);
   pstmt.setString(4,Str4);
   pstmt.setString(5,Str5);
..................
}


i am getting error at this line -->     " pstmt=
connection.prepareStatement("Insert into Customer
values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)");"


please let me know the reason for error and give some alternative way.

thanks in advice
Loving Sankar

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html