Hi Jeffro,
I don't know much about the "innards" of OLE DB and how it works with
the general ODBC driver, but...
I suggest you try working directly with the ODBC driver, instead, using
MS Query. In the "Open Data Source" dialog box, go to the top right-hand
corner, where there's an icon with a "list arrow". Click the arrow, and
select MS Query, then go through the steps to use your ODBC DSN.
Note: don't try any fancy selecting or criteria, to start with.
Also, if you're in a hurry, and need to get a job done "right now",
bring the data into Excel or Access, then merge to that.
> I have set up an ODBC driver to connect to an Informix database. I can
> successfully connect and query a table in the Informix database from
[quoted text clipped - 27 lines]
> If I choose to Open in a Browser, MSIE opens but I get the error:
> Command contained one or more errors. Query could not be processed
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)
Jeffro - 10 May 2004 12:53 GMT
Thank You Cindy. Using M.S. Query seems to be working like I need it
to as can access the records I need.
Jeff