EasyMorph version 5.9.8.4 - Database Date Fields

1

I just upgraded to version 5.9.8.4, but now everytime I query a Database table and it brings in a Date column it reads it as only text. This is causing a major issue with a bunch of existing scripts.

Have you seen this error, did something change in version 5.9.8.4 where I have to change a setting somewhere?

2

Hi Chris,

That's not expected behavior. Can you please provide more details:

  • What's the database type (Postgres, Oracle, etc.) and the driver version?
  • Are you using an ODBC connector or a native one?
  • What's the exact database type of the Date field that is now imported as text?
3

Currently Microsoft SQL Server using ODBC. I am currently checking the version of the ODBC Device Driver to see if that could be the issue.

4

It looks like it was a new ODBC device driver. I have downgraded to ODBC Driver 17 for SQL Server and it appears to have resolved the issue.

2 Likes
5

Hi Chris,

Could you please let us know the name and version of the ODBC driver you experienced the initial issue with? We would like to determine the source of the issue.