Re: Urgent : ODBC Drivers under NT 4 for Informix OL

Gavin Shaw wrote: > > The message <6rs1gd$mhk$1@news.imaginet.fr> > from "Marc-Henri PAMISEUX" <mhpamiseux@clg.fr> contains these words: > > > Actually, i'm using TUN PLUS SLQ under Windows NT 4.0 to connect a windows > > application to a database under Informix online 5, installed on an HP9000 > > under HPUX 10.x. > > But i think this odbc drivers can't load more than 3000 rows... > > I have to test if my problems come from the ODBC drivers or from my > > application. So, i decide to find another ODBC Driver to test it, but i > > can't find any free or demo drivers to dowload on the net... > > A long time ago, i've been using Intersolv Datadirect ODBC. But my version > > of this product is for Windows 3.x ... > > Could you send me some links to find some Free ODBC Drivers for NT and > > Informix Online 5.0 ? > > I don't know about 'free' ODBC drivers, but I'm currently testing > SCO SQL-Retriever on a 'free' 30 day trial. There is a ~14MB download > from SCO's web site, or if you get in touch with an SCO rep they can > send you a CD. > > So far I have found it OK for queries that return a limited volume of > data, but it does seem to get disproportionately slower once the rows > start to run into thousands. I think I've returned more than 3000 rows > but I would need to check to be sure (not a work just now). Gavin Thanks for the comments re our driver. If you're having speed problems, drop me a line with details. As I put in my reply to the original posting to which you replied, speed is sometimes a function of the application. For example, SQL-Gold that we supply as a test app is not meant to handle huge amounts of data, the speed can depend on your table structure (e.g. indexed or not), e.g. MSAccess is much better at handling large results sets, and e.g. some of the VB grid controls have limits on the number of rows they can hold (but usually way above 3,000!). URL for download is: http://www.sco.com/vision/eval/ Allan