🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: another new Connection for two Resul?

#8512
From: Hartmut
Date: Fri, 16 Mar 2001 08:58
17 lines
1415 bytes
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: <3ab1d5a8_1@dnews>
Path: arc1-ca.pugleaf.net!pubnews.netcom.net.uk!diablo.netcom.net.uk!netcom.net.uk!fr.clara.net!heighliner.fr.clara.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews!217.3.246.127
References: <3ab17350_1@dnews> <3ab1b7e4$1_2@dnews> <3ab1ca4d_2@dnews> <3ab1d05d$1_2@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f74b3,706e71a4e5ab8522
X-Google-Attributes: gidf74b3,public
X-Google-ArrivalTime: 2001-03-17 07:55:22 PST
From: "Hartmut" <hartmut.kiessling@bnhof.de>
Newsgroups: borland.public.jbuilder.java.language
References:  <3ab17350_1@dnews>  <3ab1b7e4$1_2@dnews>  <3ab1ca4d_2@dnews>  <3ab1d05d$1_2@dnews>
Subject: Re: another new Connection for two Resul?
Date: Fri, 16 Mar 2001 09:58:28 +0100
Lines: 20
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: 217.3.246.127
Message-ID: <3ab1d5a8_1@dnews>
X-Trace: 16 Mar 2001 00:58:16 -0800, 217.3.246.127
Path: arc1-ca.pugleaf.net!pubnews.netcom.net.uk!diablo.netcom.net.uk!netcom.net.uk!fr.clara.net!heighliner.fr.clara.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews!217.3.246.127