Have created a linked server from SQL Server 2000 to
Informix using ODBC Datasource and it is fine.
The problem is I'm not able to read one data field from
linked server's table. When I include that specific data
filed in my SELECT statement it popups with following
error message. The datatype of that particular field in
Informix table is 'DateTime Hour to Minute'
[Microsoft][ODBC SQL Server Driver][SQL Server] Error in
Converting data type DBTYPE_DBTIMESTAMP to Datetime.
If I exculde that partcual filed from the SELECT statement
it will work. I tried with convert but it doesnt work.
Hope that someone can really help me on this.
Any helps/tips shall highly be appreciated.
Thanks & regards,