1. Mathews Paulose
  2. SnapDevelop
  3. Thursday, 8 October 2020 08:25 AM UTC

Hi,

I am using snapdevelop to convert from powerbuilder to C# api. Database used is Informix Version 12.10.FC13.

I have converted one of the data windows(C# model) and created model,as well as scaffolded the retrieve method by adding data context with connection as DSN.

I have created a user DSN with a specified connection string (Informix Driver-IBM INFORMIX ODBC DRIVER-4.10.00.15364).

I have generated all the scaffolding Controllers,Models,Services and Interfaces through the snapdevelop tool and tried to run the application and navigated to the retrieve method.

But I am getting the error as "ERROR [42000] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred."

I have tested informix connectivity from my machine and it is working fine.

Please help me out.

Thanks in advance

Marco Meoni Accepted Answer Pending Moderation
  1. Thursday, 8 October 2020 09:33 AM UTC
  2. SnapDevelop
  3. # 1
Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 8 October 2020 15:05 PM UTC
  2. SnapDevelop
  3. # 2

Informix database is not supported yet for C# projects... you can only use Informix for PowerScript projects.  Informix support is planned for SnapDevelop 2021: https://www.appeon.com/developers/roadmap#upcoming

The supported databases in SnapDevelop 2019 R3/.NET DataStore are as follows:

ASE (using ODBC) 
Azure SQL
Amazon Aurora
Amazon RDS
MySQL 
PostgreSQL
Oracle
SQL Server
SQL Anywhere (using ODBC) 
SQLite

Comment
  1. iliyan iliev
  2. Tuesday, 16 February 2021 09:44 AM UTC
I think in SnapDevelop 2019 R2 may be use custom ODBC connection !

I this case informix.Why this remove from R3 ?!
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Tuesday, 16 February 2021 10:31 AM UTC
No, nothing removed. The ODBC in 2019 R2 was for SQL Anywhere only.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Tuesday, 16 February 2021 10:33 AM UTC
Informix support is planned for SnapDevelop 2021: https://www.appeon.com/developers/roadmap#upcoming
  1. Helpful
There are no comments made yet.
Mathews Paulose Accepted Answer Pending Moderation
  1. Friday, 9 October 2020 08:46 AM UTC
  2. SnapDevelop
  3. # 3

Thanks Armeen and Marco

Comment
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.