SQL error code = -204
---------------------
Key: DNET-514
URL: http://tracker.firebirdsql.org/browse/DNET-514
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider, DDEX Provider, Entity Framework support
Affects Versions: 3.1.0.0
Environment: Win7 x64 - .NET 4.5 - VS 2012 - EF 5.0
Reporter: Rand Random
Assignee: Jiri Cincura
I installed the new .NET Provider and tried to update my EDMX Model (with
Database First) but I am getting the following in my output window:
Unable to generate the model because of the following exception: 'An error
occurred while executing the command definition. See the inner exception for
details.
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.4426206.
Generating the model took 00:00:07.6167923.
Added the connection string to the App.Config file.
Writing the .edmx file took 00:00:00.0012551.
I am creating the following Domain, since Firebird 2.5 and earlier is lacking
support for boolean:
SET TRANSACTION;
SET TERM !! ;
EXECUTE BLOCK AS BEGIN
if (exists(select 1 from rdb$fields f, rdb$types t
where f.rdb$field_name='BOOLEAN'
and f.rdb$field_type=t.rdb$type
and t.rdb$field_name='RDB$FIELD_TYPE')) then
execute statement 'drop DOMAIN BOOLEAN;';
execute statement 'CREATE DOMAIN BOOLEAN
AS SMALLINT DEFAULT 0
CHECK (value in (0, 1));';
END!!
SET TERM ; !!
COMMIT TRANSACTION;
could this be the root of the problem, and how would I fix it?
In my Database I have
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
