- Posts: 1
- Thank you received: 0
MS SQL server Reader error - Invalid Descriptor Index - timestamp
6 months 5 days ago #22452
by jvang
Hi,
i'm evaluating the product and like it.
I get this error when i read from a MS SQL Server db, both when using a direct and a ODBC connection. I have read the documentation regarding Connections and Reader and searched the forum but can't find any help.
The problem is reading a field with DataType TIMESTAMP. Is there a solution for this?
The erroris : Reader:{Reader} SQLGetDataA Failed: 07009 [Microsoft][ODBC Driver 17 for SQL Server]Invalid Descriptor Index, Field Name: timestamp
A screendump and the error log is attached.
Regards,
Júst
i'm evaluating the product and like it.
I get this error when i read from a MS SQL Server db, both when using a direct and a ODBC connection. I have read the documentation regarding Connections and Reader and searched the forum but can't find any help.
The problem is reading a field with DataType TIMESTAMP. Is there a solution for this?
The erroris : Reader:{Reader} SQLGetDataA Failed: 07009 [Microsoft][ODBC Driver 17 for SQL Server]Invalid Descriptor Index, Field Name: timestamp
A screendump and the error log is attached.
Regards,
Júst
Please Log in or Create an account to join the conversation.
6 months 5 days ago - 6 months 5 days ago #22453
by admin
Mike
ETL Architect
Replied by admin on topic MS SQL server Reader error - Invalid Descriptor Index - timestamp
Quite often the issue is related to working with blob/clob fields
Please read the following article
www.etl-tools.com/wiki/knowledgebase/invalid_descriptor_index
If this does not help please provide us with your table creation script
Please read the following article
www.etl-tools.com/wiki/knowledgebase/invalid_descriptor_index
If this does not help please provide us with your table creation script
Mike
ETL Architect
Last edit: 6 months 5 days ago by admin.
The following user(s) said Thank You: jvang
Please Log in or Create an account to join the conversation.