Re: Informix 2.80 CLI ODBC Driver

Hi Aik If you already have the Informix CLI installed on your client, then, you might want to consider using the OpenLink ST drivers. These allow you both the functionality of using your Stored procedures as well as storing the username and Password in your DSN Setup. You can download an evaluation copy from www.openlinksw.co.uk or www.openlinksw.com. Best Regards In article <6v0772$88m$1@mawar.singnet.com.sg>, "Aik Khoon" <panadol@singnet.com.sg> wrote: > Hello, > > I have a problem using this ODBC driver Informix CLI 2.80 to > execute a stored procedure with transaction. e.g. > > my stored procedure do a update statement : > > create procedure updatetab(new integer) > begin work;> update.... > commit work; > end procedure > > The problem is that it does not update the table at all. Seems like it > does not recognise the transaction. I tried the following using Intersolv > 3.10 Driver and it works fine. But I need the CLI driver because it allow > for no username and password to connect to database since the dsn already > assigned those. Or is it possible that the Intersolv driver can support > trusted host ? > > Thanks in advance. > > rgds, aik khoon > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own