>Hi Dorin !
>I have two questions slightly out of topis of this thread
>1. I installed Firebird but I can not find Firebird ODBC driver - where I can find it ? How can create a propper connection string ?
>2. What date/datetime datatypes has firebird databe. Does they allow empty dates?
Hi Josef!
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.