[Webinar] Streamline your web hosting managementRegister Today


Multi-threaded database on the network

Posted on 1999-06-29
Medium Priority
Last Modified: 2010-04-06
I tried doing a SELECT...UNION to read data from table_1 (in the current app.) and table_2 (table in a different folder), but it's not working.  So I tried doing a query on table_2 (w/ a different session) and then appending it to a temp. table (w/ TBatchMove) in the current app., but I am getting an EDBEngineError:'Attemp to mix objects from different Sessions'.  

Note: The current's app. tables are using the default session and table_2 is accessed using a different session.  

Any ideas/suggestions would be appreciated.
Question by:ocean9
  • 3
LVL 27

Expert Comment

ID: 1385348
hi ocean9,

not checked with the different sessions,
but so is it done

with physically paths
select * from "c:\pd_work\t2.db" union all select * from "c:\pd_work2\ty.db"

or with aliases
select * from ":PD_Worker:t2" union all select * from ":PD_Worker2:ty"



Author Comment

ID: 1385349
Yes, this would work fine on a local machine, but both the applications are on the network, therefore it involves .NET files so this doesn't work.
LVL 27

Expert Comment

ID: 1385350
hi ocean9,
you should try to centralize the .NET-file for each application, for each client to a shared network-drive.

Expert Comment

ID: 1385351
I don't know if kretzschmar's solutions works but i though you had to centralize the .net file for all your applications.
LVL 27

Accepted Solution

kretzschmar earned 80 total points
ID: 1385352
preventive lock ;-)

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question