Help: Interbase 6 and BDE

[Guest_imported]

I can't connect to a interbase 6 database using dialect 3 and using BDE to connect it.

 

[2ffat]

Have you updated your BDE?
James P. Cottingham

I am the Unknown lead by the Unknowing.
I have done so much with so little
for so long that I am now qualified
to do anything with nothing.

 

[Guest_imported]

Yes, but still don't work.

 

[hilbrink]

Do you get an error message?
(-:

 

[Guest_imported]

Yes. I think it's because date's and log its are
incompatible.

Dialect 1 don't accept for example:
create table (date1 date);
accepts only:
create table (date1 timestamp);

In dialect 3 I can use:
create table (date1 date);

I try to use Interbase ODBC, but some of them still in BETA
and have some errors

 

[hilbrink]

What error(s) do you get?

 

[svanels]

Can't you create the table using SQL Explorer or some other tool?
Why you use the dbe to create tables?. In most cases I create the tables in WISQL or SQL explorer, and the DBE only enters when I make the front end application.

Regards S. van Els
SAvanEls@cq-link.sr

 

[Guest_imported]

Gives me this error:

--------------------------------------------------------
General SQL error.
Column unknown
SALEDATE
Client SQL dialect 1 does not support reference to DATE
datatype.
--------------------------------------------------------