Re: logon to informix from visual basic

Jonathan Cantu <jcantu@informix.com> wrote: :sinyem@pc.jaring.my wrote: :> :> Hi all, :> :> When logging to the INFORMIX database from Visual Basic app, it takes about 5 :> minutes to establish the connection. It's ** awfuly ** slow. When testing the :> connection using Informix's ILogin, the connection is faster. Is there any way :> to speed up the connection ? Please send details solution. :> :There probably isn't a way to speed up your VB connection because as far :as I know there is no native Informix connectivity available for VB - :you need to go through ODBC, which can be very slow. That's why your :ILogin is so much faster - it uses native connectivity. The only :windows development languages that I am aware offer native Informix :connectivity are NewEra and Delphi. Be carefull, the above is not (necessarily) true. ODBC might actually be faster than "native" connectivity (from any database vendor). This all depends on the number and complexity of the layers of software that implements the connectivity. There are ways of redusing this using ODBC as well as "native" connectivity. Both Openlink and SQL Retriever, and possibly others have done this. If you use ODBC you gain the advantage of beeing able to connect to databases from different vendors, and retain the option of using vendor spesific SQL via the sql passthrough option. Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company