DB Library Error/Network Error 10054 v6.0 sp3

DB Library Error/Network Error 10054 v6.0 sp3

Post by Amin Abdul-Kari » Sun, 21 Dec 1997 04:00:00



Configuration   :       SQL 6.0 with sp3
Network protocol:       IPX/SPX
OS              :       NT 4.0 with sp3

Running a query with three joins, one outer and two inner joins causes
an error which is reported in different ways.

ISQL window : DB libary/ Network Library error 10054
                DB -Libary connection broken process dead
SQL error log: Error 7114 State 22, Level1
                Page 0 is not a valid data page

I have run dbcc checks on all the concerned tables and the results do
not flag any table. Otherwise all the queries and connections are fine.
Just this one query produces this error.

Any help would be appreciated.

Thanks,

Amin

 
 
 

DB Library Error/Network Error 10054 v6.0 sp3

Post by Neil Pik » Mon, 22 Dec 1997 04:00:00


Amin,

 Post a reproduction script - however, the likelihood is that this is
fixed on SQL 6.5 - and your only course will be upgrading.

 Neil Pike MVP/MCSE
 Protech Computing Ltd (MS Solution Provider)

 
 
 

1. HELP: Net-Library error 10054

I got the following error when I ran a simple select query:

DB-Library: Unexpected EOF from SQL Server.  General network error.  Check your
documentation.
Net-Library error 10054: ConnectionCheckForData ((null)()).

DB-Library Process Dead - Connection Broken

Does anybody know what the problem is?  Please help...

Thanks...

2. FM Mobile for Palm

3. DB-Library error 10040: DB-Library network communication layer not loaded

4. Formatting numeric values

5. General SQL error -- Win32 error 10054

6. missing dll on pc solution

7. Persistent Error 10054 when creating stored procedures....

8. Forsale Foxpro 2.5 & 2.6 with manuals & other books plus videos

9. Error 10054

10. ODBC error #10054

11. Strange Error in 6.5 (10054) resulting in dead connection