Page 1 of 1
Multiple queries using 1 TMSConnection creates multiple SQL Server sessions
Posted: Wed 09 Feb 2005 09:44
by joebloggs
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.
Posted: Wed 09 Feb 2005 09:53
by Ikar
Do you use TMSQuery.FetchAll = False?
Posted: Wed 09 Feb 2005 10:07
by joebloggs
No, FetchAll = True
Posted: Wed 09 Feb 2005 15:27
by Ikar
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