OLE DB driver question

[jprideaux]

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

[Darren...@carmax.com]

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: inform...@iiug.org
informix-list-bou cc
nc...@iiug.org
Subject
OLE DB driver question
08/03/2006 07:53
PM

John Prideaux

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

[jprideaux]

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

[Sheshnarayan Agrawal]

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.p...@gmail.com> Sent by: informix-l...@iiug.org 08/04/2006 08:23 PM

To inform...@iiug.org cc Subject Re: OLE DB driver question