ODBC Timestamp Data Types

[daniel_rasch]

I recently linked my HANA DB via ODBC with MS Access.

Everything worked fine using the HDBODBC driver.

Except data types grouping around date types.

For example types of DATE, TIME or TIMESTAMP are only displayed as TEXT fields in Access.

Accordingly any attempt in updating these fields will lead to an "SQL data type out of range" error.

Any suggestions how I could map these types successfully within Access?

Thanks

[ruesselfix]

8 years later my question: is there already a known solution for this problem?

I'm facing the same error.

Any DATE fielt does appear in MS Access as TEXT and it's impossible to update or change it with MS Access

[former_member182302]

Hi Daniel,

Can you please share the DDL of the table you are using?

Regards,

Krishna Tangudu

[daniel_rasch]

Hi Krishna,

sure, this is the SQLScript of the table I set up for testing.

The columns: CreatedAt, CreatedTime and CreatedTimesstamp have different time and date types but will be displayed as "text" columns with 255 characters.

table.schemaName = "XXXX";

table.tableType = COLUMNSTORE;

table.description = "TEST table";

table.columns = [

{name = "OrderID"; sqlType = NVARCHAR; nullable = false; length = 10; },

{name = "CreatedAt"; sqlType = DATE; nullable = true;},

{name = "CreatedTime"; sqlType = TIME; nullable = true;},

{name = "CreatedTimeStamp"; sqlType = TIMESTAMP; nullable = true;},

{name = "Currency"; sqlType = NVARCHAR; nullable = false; length = 5;},

{name = "GrossAmount"; sqlType = DECIMAL; nullable = false;

precision = 15; scale = 2; defaultValue = "0";}

];

table.primaryKey.pkcolumns = ["OrderID"];

Thanks

Daniel