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

Mathews Paulose Accepted Answer Pending Moderation
  1. Friday, 9 October 2020 08:46 AM UTC
  2. SnapDevelop
  3. # 1

Thanks Armeen and Marco

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.
Marco Meoni Accepted Answer Pending Moderation
  1. Thursday, 8 October 2020 09:33 AM UTC
  2. SnapDevelop
  3. # 3
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.