Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved C# Model Generator Error on Firebird

  1. Issue
0
Votes
Undo
  1. Yida Zhang
    Yida Zhang
  2. PowerBuilder
  3. Friday, 5 July 2019 18:04 PM UTC

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.

Attachments (1)
dw_donation.zip
How to install auto compiler using power shell scr...
PB 2019 license options
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 5 July 2019 18:11 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Yida;

   FireBird is not a supported DBMS in release 1.0

FYI:  https://www.appeon.com/support/documents/appeon_online_help/snapobjects/features_list/

Regards ... Chris

Comment
There are no comments made yet.
Responses (2)
Yida Zhang
Yida Zhang Accepted Answer Pending Moderation
  1. Friday, 5 July 2019 18:28 PM UTC
  2. PowerBuilder
  3. # 1

Hi Chris;

Thank you for the answer.

When you say it's not supported, do you mean that it's just not possible to use Firebird in the code generator? Or you mean it's possible but Appeon does not do any technical support on that? Thanks.

 

Regards,

Yida 

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. 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?
  1. Helpful
Yida Zhang
  1. Yida Zhang
  2. 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?
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.