[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 135
  • Last Modified:

Multi-threads access to an SQL database !!!

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
mars
Asked:
mars
1 Solution
 
ZifNabCommented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now