Re: another new Connection for two Resul?

Article View: borland.public.jbuilder.java.language

Article #8577

Back to borland.public.jbuilder.java.language Previous Next

#8577

From: Calvin R. Smith
Date: Fri, 16 Mar 2001 16:34

28 lines
1903 bytes

I've seen this with the jdbc-odbc bridge and this along with a few other
issues made up my mind that jdbc-odbc to hit sqlserver is not a good
solution.  Instead I've switched to using weblogic's sqlserver driver which
is a type 4 (all java) driver and works very well.  You may want to try it

"Hartmut" <hartmut.kiessling@bnhof.de> wrote in message
news:3ab1d5a8_1@dnews...
> Torsten,
>
> you're right. Stephen must use different statements at least.
>
> But Stephen's error message sounds like the typical behaviour of MS
> SQLServer (and also MS Access, I think) with JCBD-ODBC.
> The MS ODBC driver isn't able to do several queries at the same time in
the
> same connection.
>
> So, Stephen,
> if this is your szenario, though JDBC could do it by using several
> statements of the same connection,
> in this situation you have to start a new connection for the second
> statement.
>
> Regards,
> Hartmut
>
>
>

Technical Details

Message-ID: <3ab24131$1_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!sienna.impulse.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!207.201.104.90

References: <3ab17350_1@dnews> <3ab1b7e4$1_2@dnews> <3ab1ca4d_2@dnews> <3ab1d05d$1_2@dnews> <3ab1d5a8_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f74b3,706e71a4e5ab8522,start
X-Google-Attributes: gidf74b3,public
X-Google-ArrivalTime: 2001-03-16 13:56:40 PST
Reply-To: "Calvin R. Smith" <calvinrsmith@hotmail.com>
From: "Calvin R. Smith" <calvinrsmith@hotmail.com>
Newsgroups: borland.public.jbuilder.java.language
References:  <3ab17350_1@dnews>  <3ab1b7e4$1_2@dnews>  <3ab1ca4d_2@dnews>  <3ab1d05d$1_2@dnews> <3ab1d5a8_1@dnews>
Subject: Re: another new Connection for two Resul?
Date: Fri, 16 Mar 2001 09:34:06 -0700
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 207.201.104.90
Message-ID: <3ab24131$1_1@dnews>
X-Trace: 16 Mar 2001 08:37:05 -0800, 207.201.104.90
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!sienna.impulse.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!207.201.104.90

Reply to Parent Message