Re: BUG Found : DB2 OleDB Connections not closing with Framework v1.1

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Johanl (Johanl@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
> Problem : Calling .Close() or using {...} (or any combination or these)
> with a OleDBConnection does not close the connection to DB2.
>
> Solution : Uninstall Framework v1.1 Service pack 1
>
> Using : IBM OleDB Provider version ("DB2 v8.1.6.574")
> Reproducible on W2k and XP.
>
> Any solution to this problem would be appreciated as SP1 fixes some other
> issues that I had but violates the connections.
>
> This is working at another client who is using an UDB Gateway to their DB2
> with Framework 1.1 sp1

microsoft.public.dotnet.framework.adonet would be a far better venue
for this post.


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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

.

Relevant Pages

  • Re: Datadirect JDBC driver on DB2: Locks not released
    ... StarQuest has some DB2 connectivity solutions ... and a specific DB2 to SQL Server ... > (even though Autocommit is ON). ... > If autocommit is turned off and the connection is commited after the ...
    (comp.lang.java.databases)
  • RE: SQL Server 2000 Linked Server --> IBM DB2
    ... > I am trying to create a linked server connection in SQL Server 2000 to ... Creating a Linked Server to DB2 using Microsoft OLE DB Provider for DB2 ...
    (microsoft.public.sqlserver.server)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Check on ODBC connection to IBM DB2 table
    ... MSDASQL will only call into DB2 driver's SQLDriverConnect with the DSN name ... So I define as recordset and try to make the connection of the table. ... Set db2con = New ADODB.Connection ... Another idea is to have a separate database to keep the status of the DB2 ...
    (microsoft.public.data.odbc)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)