Linked Server

[addsd]

Dear All,

Have create a linked server from SQL 2000 to Informix using ODBC data source and it is fine.

The problem is, when I try execute a SELECT statement i.e. 'SELECT mtime,mDate From Table1' it popus with following error message.

'Error converting data type DBTYPE_DBTIMESTAMP to DateTime'

After excluding of 'mTime' from the SELECT statement it works well.The FiledType of mTime in Informix is 'DateTime Hour To Minute'

How can I read that particualr field ?. I tried with Convert using Varchar, DateTime etc... but it doesn't work.

Is it informix Driver problem ?.

Any tips/advise shall higly be appreciated.

Thanks in advance

Regards,
Ahmed

 

[sguslan]

Hi ahmed,

I have a similar setup connected to DB2 and some data types will not convert correctly. So what you have is probably normal. The driver is not capable of doing the correct conversion. Check the odbc manual as well as sql books online...

Try converting the datetime field into character field. I do it all the time when doing similar connections into DB2 and Oracle7.3. Check Informix manuals on the proper sql function to use for conversion.