« Previous Next »

• 10-05-2009, 4:04 AM

  ffsetit Joined on 10-05-2009, 7:52 AM Posts 2

  odbc connection pooling with Delphi 7 & IIS7 Reply Contact We have a application that utilizes a combination of ASP.net (c#) and classic ASP (Delphi 7). When running the application on Windows Vista or Server 2008 using IIS7 we experience terrible performance problems from the classic ASP pages when retrieving data from SQL. Upon investigation using SQL Profiler it is apparent that hard connections are being opened and closed rather than being pooled. We experience the same issue with IIS6 on Server 2003 however this can be worked around by enabling IIS5.0 compatibility mode. Unfortunately there seems to be no such workaround for IIS7 Does anyone have any ideas as to why odbc connection pooling does not work in IIS7 (or 6)

  Tags: ASP ClassicIIS 7classic aspdb connection problem in IIS7ASPasp 3.0IIS 7.0odbcconnection pooling

• 10-08-2009, 11:30 PM

  In reply to

  Leo Tang - MSFT Joined on 12-11-2008, 9:47 PM Posts 851

  Re: odbc connection pooling with Delphi 7 & IIS7 Reply Contact Hi, The changing of  the credential in the connection string will create a new connection. Did you specify the user name and password in the connection string ? Also, please make sure the connection pooling for the driver is enabled Setting ODBC Connection Pooling Options http://msdn.microsoft.com/en-us/library/ms709288(VS.85).aspx Leo Tang Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.

• 10-13-2009, 2:19 AM

  In reply to

  ffsetit Joined on 10-05-2009, 7:52 AM Posts 2	Re: odbc connection pooling with Delphi 7 & IIS7 Reply Contact The username and password are specified in the connection string, and the odbc connection pooling option on the driver makes absolutely no difference.

• 10-13-2009, 6:00 AM

  In reply to

  Leo Tang - MSFT Joined on 12-11-2008, 9:47 PM Posts 851

  Re: odbc connection pooling with Delphi 7 & IIS7 Reply Contact Hi, Could you try to use OLEDB connection? Also, classic ASP is always impersonating. You can enable the ASP.NET impersonation to see if it helps . As the engineers and community members in SQL Server Forum have more experience on SQL, you may get more valuable suggestion there: SQL Server Forum: http://social.msdn.microsoft.com/Forums/en/category/sqlserver/ Leo Tang Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.