1. lingaiah T
  2. SnapDevelop
  3. Monday, 11 January 2021 14:08 PM UTC

Dear Team,

I have created API links in SNAP, when I am sending post request to MSSQL server 2005. it's giving below error. 

Can anyone advise to resolve below issue.

 

System.ArgumentException: The version of SQL Server in use does not support datatype 'datetime2'.

I have changed dateTime? to DateTime also. no use.

 

Server version : MS SQL 2005

Post Request : JSON Format

 

Thanks in advance.

 

 

Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Monday, 11 January 2021 17:24 PM UTC
  2. SnapDevelop
  3. # 1

Hi Lingaiah,

 

Please keep in mind that the DataWindow Converter supports SQL Server 2016 and 2017. But still, this might be a bug. Please open a support ticket to look into this further.

 

 

Regards,

Comment
  1. Logan Liu @Appeon
  2. Tuesday, 12 January 2021 17:03 PM UTC
Hi Lingaiah,

Please note that MSSQL server 2005 is also not supported by Microsoft now.

Regards,

Logan
  1. Helpful
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 11 January 2021 17:36 PM UTC
  2. SnapDevelop
  3. # 2

Far from being an expert on sqlserver, but I think that datetime2 was introduced in sqlserver 2008 and that it's not very backwards compatible. 

https://www.databasejournal.com/features/mssql/article.php/3748721/New-Date-Data-Types-with-SQL-Server-2008.htm

Are the datetime2 fields present in your database? Then it was probably not created in sql server 2005, but maybe I don't really understand when you get "whatever" error. What error do you get when it you use 'datetime' and you say "it's no use"?

 

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.