ADO, MS SQL 2000, CursorType ctDynamic and temp tables

D6 Ent SP2, ADO 2.7, MSSQL 2000

Hi all,

i have this problem: my application works with MS SQL 2K and
ADOexpress, application uses one connection to SQL server. Most tables
on sever are opened via AdoDataset with dynamic (resp. keyset) cursor.

When any table is dynamic opened via the connection, there is no
posibility to create temporrary table (local #/ global ##), they are
may be created, byt they are droped in moment of end of execution of
the command ...

 Sample code:

  ds:=TADODataSet.Create(nil);
  ds.Connection := FTempConnection;
  ds.CommandText :='SELECT * FROM [db1]..TabA';
  ds.CursorType := ctDynamic;
  ds.CursorLocation := clUseServer;
  ds.Open;
  FTempConnection.Execute('SELECT * INTO ##KILL_ME2 FROM
[db1]..TabB');
  FTempConnection.Execute('SELECT * INTO ##KILL_ME3 FROM
[db1]..TabB');
  ds.Close;
  FTempConnection.Execute('SELECT * INTO ##KILL_ME4 FROM
[db1]..Pokus');

Only one table stays on server - "##KILL_ME4" - this one, which were
created after dataset colse. When the dataset is opened, i can see in
SQL profiler, that all commands are closed between "Audit Login" a
"Audit Logout".
 Login does this:
-- network protocol: TCP/IP
set quoted_identifier on
set implicit_transactions off
set cursor_close_on_commit off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set language us_english
set dateformat mdy
set datefirst 7

--
Is there any solution to create temporary tables? Waht can i do, if i
cant:
 1) open next connection
 2) open dataset static
 3) use normal tables insted of temporary (#/##)

Thanx you for any ideas

 Tom