Very Computer

Dear All,

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,
Ahmed

    Please don't post the same question independently in multiple
newsgroups. You are wasting the time of those trying to respond to identical
threads. See my reply in ".connect" or whatever newsgroup you posted.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )

Hi,

Thank u very much for your response.

What I understand from your reply that I have to create a view in the Informix Database and access that view from SQL Server. Isn't it ?.

Is it possible to read the informix table not from View. Because I'm not an Informix guy and I have to ask our Informix DBA to do this. I would like to setup everything from SQL to avoid the dependecies.

Actually I want to create a View in SQL with joining of 2 or 3 table from Linked server database.

Is there any other option apart from creating the View in Informix ?.

Appreciate your tips/advise.

Thanks & regards,
Ahmed

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Quote:>> What I understand from your reply that I have to create a view in the
>> Informix Database and access that view from SQL Server. Isn't it ?.

    Yes.

Quote:>> Is there any other option apart from creating the View in Informix ?.

    No. Not if the provider doesn't support some data types.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )