SEO

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