new Interbase 6 Database

[beeky]

I am tying to create a new Interbase 6 Database. If I go into IB Console, Interactive SQL, and run the creation script, Client dialect 3 appears at the bottom of the main window. But if I run the database with my Delphi 6 application, as soon as I get to a date data type, I get the error message "Client SQL dialect 1 does not support access to date data type". I tried putting the line "SQL dialect 3" in the script, but that did not work. I can use an existing database, but if I do that the database size is about 25MB, where it should be only about 4MB.

 

[MartijnTonies]

Hi,

use SET DIALECT 3 in the script and make sure you connect with dialect 3 as well (from your app). What components are you using to connect from your Delphi app?


Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com

 

[beeky]

Hi Martijn,

If I use set SQL dialect 3 in the script I get a warning 'Database dialect (1) does not match client dialect (3)'.

I am using TDatabase and TwwQuery from the Infopower components to connect.

Regards

Martin

 

[MartijnTonies]

Ah, you're using the BDE - it doesn't support SQL dialect 3, unless with some kind of registry setting and the latest version of the BDE.

Do you have the latest version, if so - read the readme, it explains how to change to dialect 3.

Better yet - drop the BDE.


Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com

 

[beeky]

Hi Martijn,

What is involved in dropping the BDE? If its easy I will do it.

Martin

 

[MartijnTonies]

Well, dropping the BDE involves removing all traces of it -> that means: No TDatabase, TTable, TQuery et all. But instead, use TIBDatabase or any other InterBase specific componentset. Alternatively, use dbExpress.


Martijn Tonies
Database Workbench - the developer tool for InterBase and Firebird

http://www.upscene.com