You want to use named pipes if SQL is on the same box as IIS. If it is on another machine, then you want IP. Also, here for best
practices:
inetserver.dbweb
Thank you. I hope this information is helpful.
Tim Coffey [MSFT]
This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your use. © 2001 Microsoft
Corporation. All rights reserved.
--------------------
| From: mailme_gx DeleteThis @hotmail.com (GX)
| Newsgroups: microsoft.public.inetserver.iis
| Subject: does odbc support connection pooling when using named pipes
| Date: 12 Sep 2003 05:58:29 -0700
| Organization: http://groups.google.com/
| Lines: 11
| Message-ID: <4a51f3f8.0309120458.5da004c0 DeleteThis @posting.google.com>
| NNTP-Posting-Host: 213.207.151.60
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1063371510 4414 127.0.0.1 (12 Sep 2003 12:58:30 GMT)
| X-Complaints-To: groups-abuse DeleteThis @google.com
| NNTP-Posting-Date: 12 Sep 2003 12:58:30 GMT
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!
newsfeed.news2me.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!postnews1.google.com!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.iis:275258
| X-Tomcat-NG: microsoft.public.inetserver.iis
|
| I have a problem with a VB.NET web application connection to an
| Informix database using ODBC.
|
| Occasionally I get "out of memory" errors, I discovered enabling
| connection pooling seems to solve this error, hovever on one of the
| machines the problem reappeared after a day or so. The only diffrence
| is that the odbc driver is using named pipes instead of TCP.
|
| Could this be related to the problem??
|
| GX
| >> Stay informed about: does odbc support connection pooling when using named pipes