List:MySQL ODBC« Previous MessageNext Message »
From:Herald van der Breggen Date:March 23 2001 7:03am
Subject:Re: dynasets
View as plain text  

Thanks for your answer. That could be a solution. I have read about this 
solution before, and I wonder how adequate, reliable and efficient this 
solution is in a multi user (about 10) situation. Do you have any 
exprience on that ?

Besides.... I just wonder.... how difficult would it be to make the ODBC 
driver dynset capable ? I have the impression that this should not be so 
difficult ? Any ideas on that ?


Pat Sherrill wrote:

> Create a link table to the MySQL Database with MS Access.  Use this as the
> DSN in your VC++ application.  This would be the easiest method IMHO.
> Pat...
> ----- Original Message -----
> From: "Herald van der Breggen" <herald@stripped>
> To: <myodbc@stripped>
> Sent: Thursday, March 22, 2001 12:17 PM
> Subject: dynasets
>> Hello,
>> I have a question about dynasets...
>> We are struggling with a large piece of Visual C++ software that uses
>> ODBC, so far on MS-Access and MS-SQL server. We want to use MySQL, but
>> sofar without luck, because ths software is written on dynasets en
>> dynasets can not be used with MyODBC (as far as I know).
>> The snapshot recordset workds perfectly, but according the the
>> documentation, a snapshot-recordset is not usable in a multi user
>> situatie (which we are facing). We did some tests, and we can confirm
>> this, unless really *huge* changes are made to the software.
>> So, we are facing the question "how can we make this software work on
>> MySQL without too many changes". Is there a way the make dynasets work ?
>> Or is there another tric ?
>> Although I have heard about trics with a
>> ms-access-in-the-middle-solution, this does not sound as a reliable
>> solution.
>> Please advise !
>> Regards,
>> Herald van der Breggen
>> ---------------------------------------------------------------------
>> Please check "" before
>> posting. To request this thread, e-mail myodbc-thread2965@stripped
>> To unsubscribe, send a message to the address shown in the
>> List-Unsubscribe header of this message. If you cannot see it,
>> e-mail myodbc-unsubscribe@stripped instead.

dynasetsHerald van der Breggen22 Mar
  • Re: dynasetsPat Sherrill23 Mar
  • Re: dynasetsHerald van der Breggen23 Mar
  • Re: dynasetsHerald van der Breggen23 Mar