UNIXODBC and SUN drivers ?

pcouas_at_infodev.fr
Date: 03/15/05 

Date: 15 Mar 2005 00:40:34 -0800

Hi,

Could i use Sun drivers for connect to unixODBC ?
My Database Vendor has not JDBC driver !
Currently isql is working with an System DSN
But I have an Error
java.lang.NullPointerException
        at sun.jdbc.odbc.JdbcOdbcDriver.initialize(JdbcOdbcDriver.java:436)

Regards

Philippe

<html>
<head>
<title>display database data</title>
</head>
<%@ page import="java.sql.*" %>

<body>

<h1 align=center>display data</h1>
<table border=1 align=center>
<tr><th>USERNAME<th>PASSWORD<th>FULL NAME<th>COMMENT</tr>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:AGI");

 Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select CODE from IFPAYS");

 while(rs.next())
 {
  String moUID=rs.getString(1);

  out.print("<tr>");
  out.print("<td>" + moUID + "</td>");
  out.print("</tr>");
 }

 con.close();
 %>
 </table>

 </body>
 </html>