C# Model Generator Error on Firebird

I was trying to generate a C# Model using the C# model generator and I got the error below:

System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 12, column 29
1
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at SnapDevelop.DbConnector.Odbc.OdbcSchemaProvider.GetColumnSchemas(String tableName, String schema)
at SnapDevelop.DbConnector.Services.DbSchemaProvider.ChangeDatabase(String databaseName, Boolean reload)
at SnapDevelop.DbConnector.Services.DbSchemaProvider.GetTable(String databaseName, String tableName, String schema)
at PowerBuilder.Exporter.DataWindow.DataWindowParser.ParseModelAttribute(DataWindowModel model, IReadOnlyDataObject dataObject, IDbSchemaProvider provider)
at PowerBuilder.Exporter.DataWindow.DataWindowParser.FillDataWindow(DataWindowModel model, IReadOnlyDataObject dataObject, IDbSchemaProvider provider)

The SQL statement in the datawindow is:

SELECT donornum,
date_received,
total_amount,
categorynum,
donationnum,
cheque_no,
notes,
eligible_amount,
dup,
transaction_id
FROM donation
WHERE donornum = :donornum
ORDER BY date_received DESC

The connection to my Firebird server was successful. And I don't understand the numbers, like there's no line 12 and column 29 in the SQL select, where are those numbers coming from?

And how can I solved this problem? When I have this error, I can not do the next step as exporting the model to a .net project.

I've attached the srd file for my datawindow for your reference.

Thank you for your help.

Comment

Armeen Mazda @Appeon
Friday, 5 July 2019 18:38 PM UTC

We cannot say whether it is possible or not because something that is not supported means we haven't tested. If we haven't tested we cannot say whether it is possible or not. But definitely no technical support on a database that is not supported. Why not use the free and open source PostgreSQL?

Helpful 0

Yida Zhang
Friday, 5 July 2019 20:02 PM UTC

We've already had a mutual product that's based on Firebird for more than 10 years. Considered converting to MySQL and PostgresSQL, had some issues with them and had to give up on that.

I'm supposing that C# Model Generator is part of SnapDevelope, if that's the case, if a nuget package as FirebirdSql.Data.FirebirdClient could be used when generating Models, will that solved this problem? If that's true, how can I do that?

In case everything fails, do you have any time line for supporting Firebird in C# Model Generator in near future?

There are no comments made yet.

Resolved C# Model Generator Error on Firebird