Re: Comment On OpenLink and/vs OpenPath ODBC
Posted in 1997
Hi Reiner, When I talk about Scrollable Cursors I mean Scrollable Cursors usable within the confines of the ODBC spec and providing the following key capabilities : 1. BOOKMARK Support 2. Ability to locate records at Absolute, Relative, First, Last locations with a Cursor 3. Support for the Static, Keyset, Dynamic & Mixed Mode Cursors - as you can see there are many type of Cursors. 4. DBMS ISOLATION LEVEL support and appreciation I know SequeLink inside out !!! I worked with the product in 1992 (hasn't changed much since then either), they had a Mirrored Cursor Concept, this is bascially a Static Cursoring (partially synchronized caching) facility. A simple way to confirm that SequeLink does not support the above is to attempt using a Cursor instensive tool such as VB 4.0's RDO you will find that it will fail ! Or even better use the GATOR facility that comes with the ODBC SDK, and then attempt to using SQLExtendedFetch and you will find your progress somewhat limited. Only 2 companies hand Cursors on the planet today , Microsoft (in its MS SQL Server 6 Driver) and OpenLink , our key difference being we are unique in our support for BOOKMARKS (absolute record markers, you can trust our Driver to take you directly to the record you want), and our wider support of Scrollable Cursors across non MS Databases such as Informix, Oracle, Ingres, Progress, Sybase, DB2, Unify. Just note that these new releases from us will be in wide beta from this week and next week depending on DBMS Engine, Informix will be available this week and do not fail to run the test mentioned above with OpenLink alongside SequeLink, you more than likely will understand why I created the company you know today as OpenLink Software. I noticed there was silence on the subject of our Session Rules book, this provides centralised configuration management across one or more DBMS types. Our Drivers can behave one way becuse your client is MS ACCESS and another becuase it is Excel, it can do this across pre sit profiles such as Operating System, Database, Username, Machine Address, Database Type, and even user definable profiles, these is what our Rules Engine is all about, sophistication like you might look to see in 1999 via ODBC/JDBC/OLE-DB or anything else that emerges in the dat access space. -- Best Regards, Kingsley Idehen President & CEO OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers Reiner Kunz <Reiner.Kunz@pr-kunz2.M.eunet.de> wrote in article <01bc21ce$7256c500$2565afc2@kunz>... > Hi Kingsley, > > Intersolv claims the same for their DataDirect Sequelink drivers. They are > not based upon I-NET and also have scrollable cursors which means that they > do not send the whole requested data set to the client apps but only a > manageable part and the rest in little chunks when requested by user. Where > is the difference of this Intersolv solution to yours? And Intersolv also > says they only have ONE driver on client side. So, as a SysAdmin I only > have to install the DataDirect Sequelink ODBC drivers ONCE on my clients > for several DB-Servers (informix, Oracle, ybase and so on). Many thanks for > your answer. > > cu Reiner > > Kingsley Idehen <kidehen@openlinksw.com> schrieb im Beitrag > <01bc2142$ba2e83e0$16879bcf@kidehen.openlinksw.com>... > > > > 2. Scrollable Cursors - We are the only company that has implemented > Server > > Based & Driver Based Scrollable cursors for Informix, this will be > > available as a wide beta next week on our Web Site: > > http://www.openlinksw.com > > >