Re: Microsoft IIS + Openlink + informix + SCO: can we?

Now, hopefully I'll be more specific in addressing your questions.... In article <6sbtps$csu$1@nclient3-gui.server.virgin.net>, "Philip Barrett" <philip.barrett2@virgin.net> wrote: > Hi. > > We're trying to run MS Internet Information Server on NT connecting via > Openlink ODBC to Informix 7 on SCO OpenServer 5.0.x > > We can make the ODBC connection, but a new Openlink "connection" gets made > for each query specified in the ASP of the web page and eventually (pretty > soon!) we run out of connection licenses. > Have you tried closing the ADODB connection after issuing your last sql statement in ASP? For example, if you're querying the customer table: <% set conn = server.createobject ("ADODB.Connection") conn.open (DSN,User,Password) sql = "select * from customers" set rsCust = conn.execute (sql) do while not rsCust.eof // assumes a positive result set of > 0 rows <insert appropriate HTML here> rsCust.movenext loop rsCust.close conn.close %> The last two lines (rsCust.close and conn.close) are what you care about in terms of the license; are you issuing one or both? On a tangent, you can set the registry in NT to maintain connection pooling, so you don't have to *necessarily* re-instantiate the ADODB connection, even though you may have to close it after every open command. -mka -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum