Re: Informix<->Q+E ODBC<->Access PROBLEMS

In article <Cw0uDA.70n@nntpa.cb.att.com>, ctm@mvuas.mv.att.com (-mosley c.t.) says: > >Are there any alternatives to the Q+E Informix ODBC driver? I an having alot >of problems with using it to connect MS Access 2.0 to Informix On-line (w/ >I-Net for Windows 5.01). >I have the Q+E Informix 5 driver and I constantly get errors in Access like >"can't find linked table" or "invalid cursor name format", especially when >attempting to open with subforms(master/detail). > >Have any vendors developed an Informix driver for Access so I can bypass >ODBC? > I have just set up the Visionware product called SQL-Retriever to enable ODBC access between MS-Access 2.0 and Informix. It works like a charm. Much better than I expected. You don't even need I-net. Retriever comes in two parts. One is specific to the host O/S & backend database (I am using Informix on a SCO platform). The other part resides on the PC end. The two parts communicate via Remote procedure calls, or via a rlogin if required. The product includes Novell TCPIP for the network software. You can also use products such as Excel, Lotus, Word & Quotro Pro to query Informix by making DDE calls on a part of SQL-Retriever called SQL-Exchange. This converts DDE into ODBC! Cost is around $500 Australian dollars. You can contact Visionware in the UK on info@visionware.co.uk They also have a US office and email address. Chris Young