Home > Archive > SQL Server Programming > October 2005 > Connection Broken
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Tor Inge Rislaa 2005-10-30, 3:57 am |
| I am updating records in my database with the procedure below. The data is
updated as it should but the Enterprise Manager (SQL Query Analyzer) gives
the error:
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
It looks like this error is blocking the SQL Server from responding to new
requests immediately (3-4 seconds) after an update.
Any ideas of what can cause this problem?
The sql call with belonging SQL procedure (below) has been tested on several
SQL servers and is working OK, but on this server I am running it against at
the moment it gives error above.
p_kontaktpersoner_endre 44, 'Tor Inge', 'Rislaa', 'TIR', 840, 'IT Manager',
'Adm', '38 15 44 30', '38 15 44 35', '900 90 700', 'myemail@vef.no', '', 1,
'Test note', 1
CREATE PROCEDURE p_kontaktpersoner_endre
@kp_id int = 1 ,
@fornavn varchar(50) = '' ,
@etternavn varchar(50) = '' ,
@initialer varchar(3) = '' ,
@ko_id int = 0 ,
@stilling varchar(50) = '' ,
@avdeling varchar(50) = '' ,
@telefon varchar(30) = '' ,
@telefaks varchar(30) = '' ,
@mobiltelefon varchar(30) = '' ,
@e_post varchar(50) = '' ,
@kategori varchar(100) = '' ,
@prioritet int = 1 ,
@merknad text = '' ,
@aktiv int = 1
AS
UPDATE kontaktpersoner
SET fornavn = @fornavn,
etternavn = @etternavn,
initialer = @initialer,
ko_id = @ko_id,
stilling = @stilling,
avdeling = @avdeling,
telefon = @telefon,
telefaks = @telefaks,
mobiltelefon = @mobiltelefon,
e_post= @e_post,
kategori = @kategori,
prioritet = @prioritet,
merknad = @merknad,
aktiv= @aktiv
FROM kontaktpersoner
WHERE kp_id = @kp_id
| |
| John Bell 2005-10-30, 7:57 am |
| Hi
You don't give the version information for SQL Server, but this may be one
cause!
http://support.microsoft.com/defaul...kb;en-us;903742
John
"Tor Inge Rislaa" <tor.ingenospam@rislaa.no> wrote in message
news:OWme0eT3FHA.636@TK2MSFTNGP10.phx.gbl...
>I am updating records in my database with the procedure below. The data is
>updated as it should but the Enterprise Manager (SQL Query Analyzer) gives
>the error:
>
>
>
> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData
> (CheckforData()).
>
> Server: Msg 11, Level 16, State 1, Line 0
>
> General network error. Check your network documentation.
>
> Connection Broken
>
>
>
> It looks like this error is blocking the SQL Server from responding to new
> requests immediately (3-4 seconds) after an update.
>
>
>
> Any ideas of what can cause this problem?
>
>
>
> The sql call with belonging SQL procedure (below) has been tested on
> several SQL servers and is working OK, but on this server I am running it
> against at the moment it gives error above.
>
>
>
>
>
> p_kontaktpersoner_endre 44, 'Tor Inge', 'Rislaa', 'TIR', 840, 'IT
> Manager', 'Adm', '38 15 44 30', '38 15 44 35', '900 90 700',
> 'myemail@vef.no', '', 1, 'Test note', 1
>
> CREATE PROCEDURE p_kontaktpersoner_endre
> @kp_id int = 1 ,
> @fornavn varchar(50) = '' ,
> @etternavn varchar(50) = '' ,
> @initialer varchar(3) = '' ,
> @ko_id int = 0 ,
> @stilling varchar(50) = '' ,
> @avdeling varchar(50) = '' ,
> @telefon varchar(30) = '' ,
> @telefaks varchar(30) = '' ,
> @mobiltelefon varchar(30) = '' ,
> @e_post varchar(50) = '' ,
> @kategori varchar(100) = '' ,
> @prioritet int = 1 ,
> @merknad text = '' ,
> @aktiv int = 1
> AS
>
> UPDATE kontaktpersoner
>
> SET fornavn = @fornavn,
> etternavn = @etternavn,
> initialer = @initialer,
> ko_id = @ko_id,
> stilling = @stilling,
> avdeling = @avdeling,
> telefon = @telefon,
> telefaks = @telefaks,
> mobiltelefon = @mobiltelefon,
> e_post= @e_post,
> kategori = @kategori,
> prioritet = @prioritet,
> merknad = @merknad,
> aktiv= @aktiv
>
> FROM kontaktpersoner
> WHERE kp_id = @kp_id
>
| |
| Tor Inge Rislaa 2005-10-31, 3:57 am |
| Thanks. Do you know where to find what version or SP my server has
TIRislaa
"John Bell" <jbellnewsposts@hotmail.com> skrev i melding
news:%23m$JfcU3FHA.2196@tk2msftngp13.phx.gbl...
> Hi
>
> You don't give the version information for SQL Server, but this may be one
> cause!
> http://support.microsoft.com/defaul...kb;en-us;903742
>
> John
>
> "Tor Inge Rislaa" <tor.ingenospam@rislaa.no> wrote in message
> news:OWme0eT3FHA.636@TK2MSFTNGP10.phx.gbl...
>
>
| |
| John Bell 2005-10-31, 3:57 am |
| Hi
Try http://www.aspfaq.com/show.asp?id=2160 and
http://www.aspfaq.com/sql2000builds.asp
In your update statement you don't need the from clause as it is the
same table as the one being updated.
John
Tor Inge Rislaa wrote:[color=darkred]
> Thanks. Do you know where to find what version or SP my server has
>
> TIRislaa
>
> "John Bell" <jbellnewsposts@hotmail.com> skrev i melding
> news:%23m$JfcU3FHA.2196@tk2msftngp13.phx.gbl...
|
|
|
|
|