Solved

Multi-threads access to an SQL database !!!

Posted on 1998-11-24
1
131 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

729 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