I'm in Finance and used to working with databases via data engines (Tableau, SAP), but have never gotten into using management studio or programming. I need to combine tables (unions and joins) from two databases (Informix and Postgres), and so I am putting a half a dozen tables into SQL server express on my laptop. I just downloaded SQL express and get this error:
"Cannot get the supported data types from the database connections" Additional Information: "EIX000: (-554) Syntax disallowed in this database server. (Ifxoledbc)"
I tested the connection and is says "Test connection succeeded."