Re: Informix/VB/And ODBC

If you do not wish to use setNet try OpenLink ODBC drivers : www.openlinksw.com We have been using this with VB ok for two years. We have had problems killing it if OnLine aborts, it stays connected to a port so OnLine will not come back up. If you don't mind using setNet try Intersolv : www.intersolv.com As to native drivers provided by MS for VB, I can't help.To get sqlca you can do this : select dbinfo('sqlca.sqlerrd1') from <table name> <table name> is the name of a table in the db, this select will get you a serial value after an insert, so we replace <table name> with name of the table with the serial column that we have just inserted into. Regards Jon Ridgway The Press Association Bill Hunt wrote in message <3458F65E.7560@merck.com>... >Hello, > What is the best way to connect to an informix database(7.22) from a >VB 5.0 app. If I use a native ODBC driver i still need i-net on the >client right? Once I make the connection, is there anyway to get the >SQLCA structure that is returned. > >Thanks for your help. >Bill > > > The contents of this message express only the sender's opinion. > This message does not necessarily reflect the policy or views of > my employer, Merck & Co., Inc. All responsibility for the statements > made in this Usenet posting resides solely and completely with the > sender.