C-Programming , SQL-2000 server remote connection:
this query fails. "spRS->Open" fails. stays closed.
without create #PGames table,,, it works fine.

i=sprintf (buf,"create table #PGames (Name nvarchar(15), DT smalldatetime) \
insert into #PGames \
select Games.Name, Games.DT \
from Games \
where Games.DT >= '10/05/01' \
select #PGames.Name as nm, #PGames.DT as dt \
from #PGames \
order by #PGames.DT asc \
DROP TABLE #PGames");

if (i >= 0){
spRS->Open(buf,
vtMissing, adOpenKeyset,
adLockBatchOptimistic, -1
);}

while(spRS->adoEOF == false){
tmp1 = UC _bstr_t(RsITEM(spRS,"nm"));
tmp2 = UC _bstr_t(RsITEM(spRS,"dt"));
,,,...
}