Thread View: borland.public.cppbuilder.database.multi-tier
4 messages
4 total messages
Started by Jinny
Wed, 12 Jul 2000 00:00
Database connections
Author: Jinny
Date: Wed, 12 Jul 2000 00:00
Date: Wed, 12 Jul 2000 00:00
17 lines
1488 bytes
1488 bytes
I am doing two-tier database application by C++ Builder 5.0 with MS Access 2000 and MS SQL server by ODBC. The question I have is if two or more instances of my database application from different machines try to access the same table of the database, only one of them is allowed to modify the data, others just can read data. Is there a mechanism to handle such situation. I understand that when the applications try to access the database, a connection is setup for each application with the database. Is there a way that before a application accesses to the database, it check the connection of the database, if there is more that one connection with the database, the application just allows its Data Controls Components to read the data; After the application which could modify the data (i.e. first application accesses to the database) closes or crashes, it release its connection with database, then the other application could access to the database and modify the data? Thank you!
Re: Database connections
Author: Mark Cashman (TeamB)
Date: Wed, 12 Jul 2000 00:00
Date: Wed, 12 Jul 2000 00:00
13 lines
1039 bytes
1039 bytes
Hi, Jinny! Access is a desktop database and so does not offer the sort of capabilities you need for this. Consider using an inexpensive (or free) client server DB like Microsoft MSDE or Interbase (http://www.interbase.com) ------ Mark Cashman, TeamB C++ Builder http://www.temporaldoorway.com/programming/index.htm C++ Builder, JBuilder programming information Home of The C++ Builder Programmer's Webring - Join us! ------
Re: Database connections
Author: Jinny
Date: Fri, 14 Jul 2000 00:00
Date: Fri, 14 Jul 2000 00:00
26 lines
1418 bytes
1418 bytes
Thank you Mark. If I use client/server DB like MS SQL server or interbase, in the database application how could I detect the connection to the database before I connect it? Which kind of technologies I should investigate? Thanks again! Looking forward to your reply! Jinny Mark Cashman (TeamB) <mcashman@temporaldoorway.com> wrote in message news:396CDD72.4BFC3BC9@temporaldoorway.com... > Hi, Jinny! > > Access is a desktop database and so does not offer the sort of > capabilities you need for this. Consider using an inexpensive (or free) > client server DB like Microsoft MSDE or Interbase > (http://www.interbase.com) > > ------ > Mark Cashman, TeamB C++ Builder > http://www.temporaldoorway.com/programming/index.htm > C++ Builder, JBuilder programming information > Home of The C++ Builder Programmer's Webring - Join us! > ------ > >
Re: Database connections
Author: Mark Cashman (TeamB)
Date: Fri, 14 Jul 2000 00:00
Date: Fri, 14 Jul 2000 00:00
13 lines
1067 bytes
1067 bytes
Hi, Jinny! Most client / server databases will take care of issues like locking and making sure you access the latest versions of data. Interbase also supports interprocess notification of changes. ------ Mark Cashman, TeamB C++ Builder http://www.temporaldoorway.com/programming/index.htm C++ Builder, JBuilder programming information Home of The C++ Builder Programmer's Webring - Join us! ------
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads