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

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