Re: OLEDB, sql server, and unmanaged heap memory leak Options

Tech-Archive recommends: Fix windows errors by optimizing your registry

Walter Wang [MSFT] (wawang@xxxxxxxxxxxxxxxxxxxx) writes:
What's the MDAC and SQL Server version you're using? Previously we have
some known issue on the ODBC driver in some version, such as this one:

#FIX: Performance degradation and memory leak in the ODBC Driver for SQL
Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;814410

Walter, pb is using OleDbClient in .Net, with SQLOLEDB as the the OLE DB
provider. Note that OleDbClient does not permit you to use MSDASQL
(OLE DB over ODBC), so memory leaks in ODBC has very little to do with it.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: SQL Losing Data
    ... the other problem wasn't a SQL Server thing. ... And I would argue that it was an ODBC driver issue, solely, not even Access. ... sidebar shows a pencil, indicating that edits are being performed. ... I've tried using Profiler in the past and found it a bit unwieldy. ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL Server 2005 "Left outer join" return nothing through ODBC call
    ... Some outer joins suddenly returned empty resultsets on SqlServer 2005 in 2000-compatibility-mode, but only within our application. ... The same query executed in Query Analyzer just worked fine. ... We finally solved that issue by upgrading to the latest SqlServer ODBC driver which can be found at: ... It did work for SQL Server 7.0 and SQL server 2000. ...
    (microsoft.public.sqlserver.odbc)
  • Re: localized ODBC driver datetime issue
    ... which I use to connect to MS SQL Server 2003. ... SS> format, because this format does not correspond to the Russian date ... SS> was a way to know the language used by the ODBC driver, ...
    (microsoft.public.data.odbc)
  • Re: dts retrieves 0 rows when scheduled...
    ... Have you tried logging in as the SQLAgent service account and running the ... job/checking out the ODBC driver? ... > There is no error massage i can trace in sql server or in any of its logs, ... > the job just passes gracefully by the dts data transfare tasks, ...
    (microsoft.public.sqlserver.dts)
  • Re: Connection with MS-SQL server
    ... http://www.actualtechnologies.com just released an ODBC Driver for Microsoft ... SQL server. ... > But this I know, and know full well: / I do not trust thee, Cage from Hell. ... > unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe ...
    (RedHat)