We switched to 1.5 when was Release Candidate 5.
For the project I'm working on now, I use version 1.5, because of new features. This month I think that will be the final release.

One thing, don't use .GDB extension for databases. For some reasons, .GDB extension is included in System Restore stuff. All database operations will be slowed down (connections, updates). I'm sure that this has nothing to do with the fact that is the default extension for Interbase databases and Interbase is broadly used :-)


>Great thanks !
>
>What version you use - 1.0 or 1.5 ?
>
>
>>
>>1. We use the IBPhoenix open source ODBC driver , www.ibphoenix.com. No problems so far.
>>The connection string is:
>>lnFBSqlConnH = SQLSTRINGCONNECT([PROVIDER=MSDASQL;DRIVER=Firebird/InterBase(r) driver;DBNAME={server}:{database_full_path};UID={user};PWD={password}])
>>for versions 1.0 and 1.5
>>
>>or
>>
>>lnFBSqlConnH = SQLSTRINGCONNECT([PROVIDER=MSDASQL;DRIVER=Firebird/InterBase(r) driver;DBNAME={server}:{database_alias};UID={user};PWD={password}])
>>only for 1.5.
>>
>>2. (DATE - as in VFP, TIME - no equivalent, TIMESTAMP = fox DATETIME. No, it doesn't allow empty dates, but allow null in columns.
>>
>>I recommend you IBExpert, the free personal edition, for a start. It is a nice tool.