Data Shaping / Hierarchical recordsets "error"

[hdougl1]

I can't interpret this error in order to debug my SQL. Any suggestions would be greatly appreciated.

ERROR:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).

/Track2kShape.asp, line 94

SQL:
SHAPE {SELECT t2.Pallet_Schedule, t1.Pallet_Target, t2.totals, t1.Pallet_ID FROM (SELECT a1.Pallet_Schedule, a1.Pallet_Target, c1.PrimaryContact, a1.Pallet_ID FROM Pallet a1, UserData c1 WHERE (a1.pallet_id = c1.pallet_id)) t1 join (SELECT a1.Pallet_Schedule, count(b1.Pallet_ID) Totals From Pallet a1, UserData b1 WHERE (a1.pallet_id = b1.pallet_id) GROUP BY a1.Pallet_Schedule) t2 ON t1.pallet_schedule = t2.pallet_schedule ORDER BY t1.Pallet_Schedule} Append ({select User_acid, User_Name, User_Id, Pallet_ID from userdata} As User Relate Pallet_Id to Pallet_ID)

 

[prasadalone]

hi

i think it must be networking problem if you are using local server then check your network

bye

prasad
sawantprasad2001@yahoo.com

 

[hdougl1]

Thanks but it's not the network if I run a more simpler version I don't get any error's i.e.

SHAPE {SELECT Pallet_Schedule, Pallet_Target, Pallet_ID From Pallet} Append ({select User_acid, User_Name, User_Id, Pallet_ID from userdata} As User Relate Pallet_Id to Pallet_ID)