Multiple queries using 1 TMSConnection creates multiple SQL Server sessions
Multiple queries using 1 TMSConnection creates multiple SQL Server sessions
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.
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
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