From: Michael Widenius Date: March 14 1999 2:30pm Subject: myodbc & Optima++ 1.5 List-Archive: http://lists.mysql.com/myodbc/28 Message-Id: <14059.51018.509679.592611@monty.pp.sci.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "Roger" == Roger Cooper writes: Roger> I am attempting to get the combination of MySQL (on a Linux box) to talk to Roger> Optima++ on a MS-Windows98 box via mysqlOdbc (2.50.1700) Roger> I have this working well using MS-Access. Roger> When I use Optima++ I get the form working, the test says connection is Roger> achieved but when I try and scroll through the records (with a navigation Roger> control) I can only go forwards one record at a time. I cannot go backwards Roger> or use the go to either end of the record set. Roger> Any ideas, does this have something to do with the lack of support for Roger> cursors? Hi! MySQL supports full SQLExtendedFetch syntax, which should be enough for any ODBC application to give you full scrolling. It may however be that for Optima++ the above is not enough but it also needs cursor support. In this case you may be able to specify that you want Optima++ to use manager side cursors insert of server side cursors to solve this. Regards, Monty