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.
>>
Thread |
---|
• dynasets | Herald van der Breggen | 22 Mar |
• Re: dynasets | Pat Sherrill | 23 Mar |
• Re: dynasets | Herald van der Breggen | 23 Mar |
• Re: dynasets | Herald van der Breggen | 23 Mar |