Problems in Client/Server Implementation of an MFC application

Dear All,


I am doing a project , which is an MFC application (MDI)
.. Now its a standalone application with MS Access as the "Back end". I
have used ADO to made the connection.



Now I want to make this application to work for several clients
at the same time . I also want this application to communicate with 3
different types of Database .

1) MySQL

2) MS SQL Server

3) Oracle


My application should connect with any of the above DB , without making
any problem..


Can I make a general implementation by using ADO ?


What are the precautions I have to take to implement this ?


I think ,I have to face the problems of "concurrent write/reads " to
the DB...How can I overcome this ?


Now I am using Multiple SQL queries for multiple table updations.
Whether I can use transactions to avoid data loss during multiple table
updations...?

But I think MySQL won't support transactions...Is there any other
option?




Can any one pls give me a suggestion ...?


Thanks in advance...


Vinod Sankar

.

Relevant Pages

  • Re: VB 6 and MS SQL Server 2000 - (Yudkin)
    ... Since you have multiple SELECT statement, ... If I need to use ADO, what components do I have to include in my project? ... GetClipString is an RDO API. ... SQL SP's have no concept of event flows. ...
    (microsoft.public.vb.general.discussion)
  • Re: commandBuilder Update SQL generation for > 1 table?
    ... > allow updates of ad-hoc queries in a data grid involving multiple ... In old school ado, you'd have a bitch of a time grabbing a ... recordset from SQL Server and having it elegantly created in excel. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO and Multithreading
    ... >I am devloping av program for merging PDF-files at specific times during the ... Multiple merges can occur at the same time and therefore I will use ... >I am also able to get access to the database using ADO and retreive data. ...
    (alt.comp.lang.borland-delphi)
  • Multiple database deamons, single LVM backend?
    ... were using MySQL and were using multiple MySQL servers, ... own CPU + disk which replicate to each other. ...
    (comp.databases)
  • Re: Microsoft Access and Multiple result sets
    ... > With ADO v1.1 you can return multiple result sets via a single DataReader. ... the Jet OleDb provider does not support multiple SQL commands. ...
    (microsoft.public.data.ado)
Loading