Solved

Multi-threads access to an SQL database !!!

Posted on 1998-11-24
1
129 Views
Last Modified: 2010-04-04
Hi,

 In the documentation, it said that if we access to the same
SQL database with threads, we must create one session for one thread.

I've created an application which has opened an SQL database
and then has started two threads to query the same database.
The application works fine and is programed by using BDE functions.

1) Could you explain me the use of multiple threads accessing the same database, one per session.
2) Is my application reliable by using one session and two threads ?
3) What does it must be protected between threads, a session, a database or a table handle ?

Thank you

dan
0
Comment
Question by:mars
1 Comment
 
LVL 8

Accepted Solution

by:
ZifNab earned 200 total points
ID: 1347753
Hi mars,

look for this at a technical paper of Inprise :

http://www.inprise.com/devsupport/delphi/ti_list/TI3005.html

and Brian Delumpa's article :

http://www.delumpa.com/tips/db/db01.htm

Regards, Zif.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

685 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