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