1. iliyan iliev
  2. PowerBuilder
  3. Friday, 16 August 2019 11:08 AM UTC

I try to generate classes with C# Model Generator.

DB Connection is ODBC - informix.When i test connectiion PB say is ok.

When i try generate classes give me excetption

 

 

System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred. 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)

Any tested with ODBC connection ?!

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 16 August 2019 13:24 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Iliyan;

FYI

  Informix is not a supported DBMS in PB2019's C# Web API feature. 

Regards.. Chris

Comment
  1. iliyan iliev
  2. Friday, 16 August 2019 13:34 PM UTC
Thanks :) Do you have information will be added informix ?!
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 16 August 2019 16:52 PM UTC
AFAIK, Nothing in the immediate future. The issue could also be that Informix does not yet provide a .Net Core DB driver. Please feel free to create a support ticket as an enhancement request for this DBMS.
  1. Helpful
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from this question.