hello dears, i'm using Sql database. i have made JDBC/ODBC bridge. in tables my all fields are text. i need only SELECT Query for such i have written as this... String simple= "SELECT meaning FROM meaning "+" where word '"+s+"' "; Statement= connection.createStatement(); ResultSet=stmt.executeQuery(simple); i'm receiving this message when i'm running my Gui Application " Connection Error[Microsoft][ODBC SQL Server Driver][SQL Server] The text,ntextand image data type can not be compared or sorted except when using IS NULL or LIKE Operators." and when i'm clicking on listner buttons my apllication hanged and error come this: error at Action Performed Fine null Kindly help me Thank You
hey sweetie, better generate the SQL Query and try to run it from SQL Analizer in SQL-Server and check what happens or POST the QUERY generatet. Then only anyone would be able to help you. You can capture the Query either printing it in Java Console or in Query Profiler of SQL-Server. Regards Javahunk
0
