Re: dynasets

[Pat Sherrill]

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.
>