Multiple queries using 1 TMSConnection creates multiple SQL Server sessions

joebloggs · Post by **joebloggs** » Wed 09 Feb 2005 09:44

If you have a project with one TMSConnection and multiple query components all linked to the connection, the application when run creates multiple sessions in SQL server. So, if one query creates a #table another query can not access that table. WHY??? Please advise. All default settings are used.

Ikar · Post by **Ikar** » Wed 09 Feb 2005 09:53

Do you use TMSQuery.FetchAll = False?

joebloggs · Post by **joebloggs** » Wed 09 Feb 2005 10:07

No, FetchAll = True

Ikar · Post by **Ikar** » Wed 09 Feb 2005 15:27

We couldn't reproduce the problem.
Please send us complete small sample to demonstrate it and include script to create server objects.

Please supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in Info sheet of TMSConnection Editor