Oninit cdi / Archive
Talk to an expert →

OLE DB driver question

Posted in 2006

Topics: Installation, Setup & Upgrades, Storage & Space Management, Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing, Networking & sqlhosts Configuration

jprideaux — — source: Usenet: comp.databases.informix

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

↪ replying to jprideaux
Darren_Jacobs@carmax.com — — source: Usenet: comp.databases.informix

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

↪ replying to Darren_Jacobs@carmax.com
jprideaux — — source: Usenet: comp.databases.informix

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

↪ replying to jprideaux
Sheshnarayan Agrawal — — source: Usenet: comp.databases.informix

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

Related threads

Glossary