Re: Comment On OpenLink and/vs OpenPath ODBC

Hi Boris, We have a SendSize and ReceiveSize facility that deals with this problem, all you have to do is modify these entries via the following Registry entry : HKEY_LOCAL_MACHINE\\SOFTWARE\\ODBC\\OPENLINK.INI\\Communications Make the ReceiveSize something like 20,000 as opposed to 16,000. On the Server side modify the matching Rule Book (oplrqb.ini) section ([Communications]), this time set the Sendsize key-value to 20,000 as this needs to match your new setting on the client. I hope this helps. -- Best Regards, Kingsley Idehen President & CEO OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers Boris Niyazov <boris@hal2000.law.columbia.edu> wrote in article <330DC609.B37@hal2000.law.columbia.edu>... > I was testing Openlink ODBC for Online 5.x a while ago and found that it > fails when I retrive more than a certain number of columns from a table > with big enough number of columns (at least 27).( I couldn't import such > tables to MS Access either). > > I reported this to Openlink providing them logs in debug mode - they > haven't got me back, yet. > ======================================================================= > Boris Niyazov Ph: 212-854-4094 > IT Department Fax: 212-316-2623 > Columbia Law School Email: ban5@columbia.edu > > > Nils Myklebust wrote: > > > > cms@sprynet.com (Jeff Stevens) wrote: > > > > : I am researching a project using ODBC for an Informix > > :database. I have come upon two drivers (OpenLink and OpenPath) that > > :include a service running on the server to expedite the transactions. > > : Is there anyone out there using either of these products and > > :be willing to share some comments? > > > > We use OpenLink and are very happy with that. > > I have only looked at the web pages of OpenPath > > (http://www.openpath.com). It's a serever based product which is the > > only viable solution, but there is no mention of all the other > > functionality that is so important with OpenLink. The key issue is > > security, but there are several others. You should read the OpenLink > > whitepaper on ODBC available at > > http://www.openlinksw.com/docs/product.html > > Unfortunately it's only available as an MS Word document in a zip > > file. If you have problems with this they'll surely send it to you if > > you ask them. I assume it will also shortly be available in html so > > you can read it directly. > > Noone should make a choice of ODBC drivers without reading this > > whitepaper first. > > > > : Has anyone actually switched to these products after trying to > > :use ODBC from Informix(CLI) and Intersolv which use I-Net? > > > > It's quite some time ago we made this switch after having too much > > trouble with these products, and realizing the incredible security > > issues that they do not even attempt to adress. For this last reason > > they are totaly useless for us. > > > > :Any help would be greatly appreciated. > > : > > :Jeff Stevens > > :CMSystems > > :Aurora, CO > > > > Nils.Myklebust@idg.no > > NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway > > My opinions are those of my company > > The Informix FAQ is at http://www.iiug.org >