There is known problem (Defect # idsdb00001322) in Informix OLEDB Provider
related to TEXT data type with respect to SQL Linked Server. I would
suggest you to touch base with your IBM Informix Tech Support to get more
status on this defect.

Thanks
-Shesh




"jprideaux" <john.prideaux@gmail.com>
Sent by: informix-list-bounces@iiug.org
08/04/2006 08:23 PM

To
informix-list@iiug.org
cc

Subject
Re: OLE DB driver question






Four part name gets me there. Shesh also suggested this. It looks
like there is a problem with text and blob columns (which are in
stores_demo), but I don't have any in the SE database I am planning on
migrating.

Thanks so much for the help! :-)

John

Darren_Jacobs@carmax.com wrote:
> Fully qualify you four part naming convention and let me know.
>
> select tabid from <linked servername.dbname.owner.tabname>
>
> and or try "select * from openquery(linked server name here, 'select
tabid
> from systables where tabname = " tabname")
>
>
>
>
> "jprideaux"
> <john.prideaux@gm
> ail.com> To
> Sent by: informix-list@iiug.org
> informix-list-bou cc
> nces@iiug.org
> Subject
> OLE DB driver question
> 08/03/2006 07:53
> PM
>
>
>
>
>
>
>
>
> I am having problems using 4 part names to access an Informix IDS
> Express database configured as a linked server on a Windows 2000/SQL
> Server 2000 machine. I get the following in response to "select tabid
> from janusstores..informix.systables" (actually, from any query):
>
> [OLE/DB provider returned message: E42000: (-201) A syntax error has
> occurred.]
> OLE DB error trace [OLE/DB Provider 'Ifxoledbc'
> IDBSchemaRowset::GetRowset returned 0x80040e37: ].
> Msg 7311, Level 16, State 2, Line 1
> Could not obtain the schema rowset for OLE DB provider 'Ifxoledbc'. The
> provider supports the interface, but returns a failure code when it is
> used.
>
> Informix Server:
> I have IDS Express 10.00.TC3R1ET on a Windows 2003 R2 server and have
> configured a dbspace named janus, in which I created the stores_demo
> database.
>
> SQL Server:
> I have installed ClientSDK 2.90.TC5. I configured setnet32 to talk to
> IDSE server, and I created an ODBC connection (IfxJanus) to verify that
> ODBC connections will work. I then configured a linked server
> (janusstores):
> Product name: Ifxoledbc
> Data source: stores_demo@janus
> Provider string: Ifxoledbc.2;password=badpasswd;User
> ID=informix;?DataSource=stores_demo@janus;Persist Security Info=true
>
> Setnet Config:
> IBM Informix Server: janus
> HostName: janus
> Protocolname: onsoctcp
> Service Name: 1526
>
> Openquery syntax works fine: select * from openquery(janusstores,
> 'select tabid from systables')
>
> Any help would be appreciated.
>
> John Prideaux
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list