Re: Problem with SP3 JDBC Driver for SQL Server

grantmitchell7_at_yahoo.com
Date: 11/08/04 

Date: 8 Nov 2004 09:40:52 -0800

Shreyas Kaushik (shreyask@gmail.com) wrote in message news:<eMtbpzUxEHA.2564@TK2MSFTNGP12.phx.gbl>...
> Hi,
>
> I noticed an interesting behaviour. When the autoCommit is turned off, I am not able to use the same connection handle to create multiple Statement/PreparedStatement handles.It goes into Manual Transaction Mode and says cannot clone connections.
>
> Is this a bug?? Can someone give some pointers here.
>
> thanks
> Shreyas
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

This is one of the number of unfortunate consequences of the fact that
the driver silently creates >1 connection to the database when you
create > 1 statement. This is an example of what I was referring to in
my post in this group on 10/27 comparing the free MS driver to
comercial drivers.

So, well, yes its free but you have to deal with issues like this
one.. I guess you get what you pay for..

Relevant Pages

  • Re: [9fans] Writing device drivers
    ... Because I have a background with low-level languages like ... understanding the _why_ of using pointers in C has eluded ... I know this bears little relation to a device driver living in ... since you want to write a Plan 9 ...
    (comp.os.plan9)
  • Re: KMDF Interface : is it possible to use a c++ class ?
    ... function pointers you pass in must be static pointers since the caller will ... I'm developing a driver similar to Toaster example using Kernel Mode ... Is it possible to create an interface to export a c++ class instead of c ... functions with WdfDeviceAddQueryInterface? ...
    (microsoft.public.development.device.drivers)
  • Re: Multifunction printers for ubuntu?
    ... any pointers to get this to work? ... I just stick an SD card into the reader slot and it appears on the ... of what it's found (I have a Hauppage TV card in the box as well and Xsane ... I had to manually find the correct driver as for ...
    (Ubuntu)
  • Re: Emulate a virtual COM port
    ... IOCTL it has in there (At passive and dispatch level). ... > I have to emulate a virtual COM port in our existing functional USB ... How do I create a virtual COM port when the driver is loaded and ... > Any pointers to the API to be used or any pointers to the sample code ...
    (microsoft.public.development.device.drivers)
  • Re: A confusion about the stream interface driver
    ... The exact same thread of the application is what runs in the driver the ... system simply changes the process context the thread is running in. ... any pointers embedded in the data those direct pointers refer to are NOT ...
    (microsoft.public.windowsce.embedded)
Loading