General network error

I am running on Win2k, SQL Server 2000 (sp3), MDAC 2.8 and using a
TCP/IP client connection.

I get this error when attempting to restore a database.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(WrapperRead()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
Check your network documentation.

Does anybody know how to resolve this issue?

ThanksHi

Have you checked that there is not a network problem? Try a different port,
check no errors in the event log ...

John

"CD" <carl.davis@.gmail.com> wrote in message
news:fceeddde.0408270623.5c9c9fec@.posting.google.c om...
> I am running on Win2k, SQL Server 2000 (sp3), MDAC 2.8 and using a
> TCP/IP client connection.
> I get this error when attempting to restore a database.
>
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
> Check your network documentation.
>
> Does anybody know how to resolve this issue?
> Thanks|||CD (carl.davis@.gmail.com) writes:
> I am running on Win2k, SQL Server 2000 (sp3), MDAC 2.8 and using a
> TCP/IP client connection.
> I get this error when attempting to restore a database.
>
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
> Check your network documentation.
>
> Does anybody know how to resolve this issue?

That's bad. It appears that your SQL Server thread experiences an
access violation, or other serious execution error and termintates
your thread. This could be because the backup is corrupt or because
of a hardware problem on the disk you are trying to restore to.

If you look in the SQL Server error, you should find a stack dump, but
it is unlikely that this will give you any useful information.

If you are in serious need of that data, you should open a case with
Microsoft.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"CD" <carl.davis@.gmail.com> wrote in message
news:fceeddde.0408270623.5c9c9fec@.posting.google.c om...
> I am running on Win2k, SQL Server 2000 (sp3), MDAC 2.8 and using a
> TCP/IP client connection.
> I get this error when attempting to restore a database.
>
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (WrapperRead()).
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
> Check your network documentation.
>
> Does anybody know how to resolve this issue?
> Thanks

Check out
http://support.microsoft.com/defaul...2&Product=sql2k
as it relates specifically to your issue.

Kevin

funny sql

The following sql updates 300 records(3000 records in the
marc_POt_lu_rd_post_code table) but the select element only returns one row.
I am attempting to update the 3000 rows which it does but it does it
incorrectly in that the results set from the select portion does not match
what the results set returns after the update. I added the extra postcode
criteria in the select to isolate what the update does but it still updates
the 3000 rows. Weird?
UPDATE marc_POt_lu_rd_post_code
SET County_id = c.County_id,
County_desc = c.County_Desc,
Parent_County_Id = c.Parent_County_Id,
Parent_County_desc = c.County_desc,
Sector_Id = d.Sector_Id,
Sector_Desc = d.Sector_Desc,
Area_Id = e.Area_Id,
Area_Desc = e.Area_Desc
-- Select *
FROM Pot_lu_County_Area_PostCodes a,
QUINN_st..GET_BCP_H_POSTCODES b,
Pot_lu_county c,
Pot_lu_Sectors d,
Pot_lu_Areas e
WHERE a.Postcode = b.Four_Char_Post_Codes
AND b.COUNTY = c.County_Desc
AND b.SECTOR = d.Sector_Desc
AND b.AREA = e.Area_Desc
and a.Postcode = b.Four_Char_Post_Codes
and b.Four_Char_Post_Codes = 'mk40'found the issue
"marcmc" wrote:

> The following sql updates 300 records(3000 records in the
> marc_POt_lu_rd_post_code table) but the select element only returns one ro
w.
> I am attempting to update the 3000 rows which it does but it does it
> incorrectly in that the results set from the select portion does not match
> what the results set returns after the update. I added the extra postcode
> criteria in the select to isolate what the update does but it still update
s
> the 3000 rows. Weird?
> UPDATE marc_POt_lu_rd_post_code
> SET County_id = c.County_id,
> County_desc = c.County_Desc,
> Parent_County_Id = c.Parent_County_Id,
> Parent_County_desc = c.County_desc,
> Sector_Id = d.Sector_Id,
> Sector_Desc = d.Sector_Desc,
> Area_Id = e.Area_Id,
> Area_Desc = e.Area_Desc
> -- Select *
> FROM Pot_lu_County_Area_PostCodes a,
> QUINN_st..GET_BCP_H_POSTCODES b,
> Pot_lu_county c,
> Pot_lu_Sectors d,
> Pot_lu_Areas e
> WHERE a.Postcode = b.Four_Char_Post_Codes
> AND b.COUNTY = c.County_Desc
> AND b.SECTOR = d.Sector_Desc
> AND b.AREA = e.Area_Desc
> and a.Postcode = b.Four_Char_Post_Codes
> and b.Four_Char_Post_Codes = 'mk40'
>