1. iliyan iliev
  2. PowerBuilder
  3. Friday, 16 August 2019

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 Accepted Answer Pending Moderation
0
Votes
Undo

Hi Iliyan;

FYI

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

Regards.. Chris

Comment
Thanks :) Do you have information will be added informix ?!
  1. iliyan iliev
  2. Friday, 16 August 2019
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. Chris Pollach
  2. Friday, 16 August 2019
There are no comments made yet.
  1. Friday, 16 August 2019
  2. PowerBuilder
  3. # Permalink


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