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.