> You don't change the dialect this way. Dialect is actually structural and
> tied to the dataset. The reason you can set that is if you were about to
> call the CreateDatabase method.

The database is a IB6 database and I can connect, but if I do the
query SELECT * FROM MYTABLE, I get an error saying:

"Data type unknown. Client SQL dialect 1 does not support
reference to DATE datatype"

However, I can do the same query using IBX and IBConsole and it
works. That's why I was trying to manual set the Dialect, as we are
using Dialect 3 data types.


James Bunting

Systematic Marketing Ltd
http://www.systematicmarketing.com
http://www.ukindex.co.uk