I've installed mysql 4.0.18 database server, and myodbc 3.51 driver on windows 98 machine. I've also installed Oracle Dev2000 as my front end. When I try to test the connection it connects successfully. When I try to add records using my design program in oracle dev2000 it works fine.
My problem is that when I try to edit and delete my existing records using oracle dev2000 it gives me an error of "FRM-40501:ORACLE error:unable to reserve record for update and delete." And then when I try to see the details of the error by pressing shift-F1 it shows "[MySQL][ODBC 3.51 Driver][mysqld-4.0.18]You have an error on your SQL syntax.Check the manual that corresponds to your MySQL server version for the right syntax to...." Maybe you can help me with my problems, thanks! __________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]