InterBase 6.0/MFC/Pesimisstic Locking

[SpenBabe]

We have written a MFC package that connects to a Unix-based SQL server using CDatabase/CRecordset classes. We are experimenting with alternative SQL databases & have hit a problem with Interbase 6.0 & Easysoft's ODBC driver. Our software occasionally has a need to forcibly lock a single record. This is done using "SELECT col,col... FROM file WHERE col='whatever' FOR UPDATE" Under Interbase, the record can still be updated but another connection can also update it.

We don't have enough time to evaluate Interbase (& other databases) in depth, so is there anyone out there who's had similar problems.

Thanks
Spen

PS: What does everybody think of Interbase as a product compared with MS-SQL or MySQL?

 

[2ffat]

>> What does everybody think of Interbase as a product compared with MS-SQL or MySQL?

FYI, There is an article in March 5, 2001 EWeek print edition that reviewed MySQL. Their take was that MySQL lagged behind InterBase in Transactions, ODBC, and SQL support. I don't know if the article is available on their web site yet.

Have checked out

http://www.interbase2000.org

for the latest bug/patch release? James P. Cottingham

http://www.ivcusa.com

 

[Guest_imported]

MSSQL is just for windows ...
MySQL is just (or mainly) for linux ...

Interbase is fine everywhere (I used it in Win311,Win9x,NT,linux (suse an redhat), solaris and now I'm trying netware (just to know if it can!) ...

 

[SpenBabe]

Thanks 'IB Robert'

As you can see it's several months since I posted the original question.

We have since gone down the InterBase 6.0 route wonder why we didn't do it sooner !

What a joy to find a database that's easy to set-up, easy to administer & works on nearly every platform we throw it at !!!!!


Spencer Window (not a joke name)