Hi,
I have Oracle database 19c on SUSE Linux server. I configured unixODBC to access tables in MS SQLServer. I tested with isql command and everything works fine. After that I configured HS and listener and I created Database link and I got data form SQL Server.
The problem occure if the table in MS SQL Server contains column Time. I got all data from that table, but the data from column containg Time. This field is not shown at all if I use describe command.
I tried this with different tables and the result is always the same. I also tried the same situation on Oracle Linux with version 12c and I have the same situation. isql command (for test ODBV) shows Time column.
After that I did the same on Windows server with database 19.23 and another server with Oracle XE 10 and everything works fine, including Time column.
Is there any idea how can I solve this problem?
Thanks and Kind regards.