Re: dynasets

[Herald van der Breggen]

Pat,

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 ?

Regards,
Herald

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 "http://www.mysql.com/Manual_chapter/manual_toc.html" 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.
>>