Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: SQL exception with memo datatype


Message #1 by Mathy V Arumugam <mathy.v.arumugam@j...> on Thu, 25 Apr 2002 12:04:19 -0700
Hi,

I have SQL exception error on MS Access memo field.  I have defined
remarks as a MEMO datatype and using JDBC-ODBC driver to access data.

 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   Connection con = DriverManager.getConnection(url,uid,passwd);
   Statement stmt = con.createStatement();

  qryb="select  remarks " +
      "from definition_tbl where desc_id= "+descId+ " ORDER BY
definition_tbl.rowId,definition_tbl.subId";
      rsa = stmt.executeQuery(qryb);
      while(rsa.next())
      {
       String dbremarks=rsa.getString(1);
     }

error:
--- SQLException caught---

Message:  null
SQLState:  null
ErrorCode:  0

Thanks a lot for any advice!!!

Mathy




  Return to Index