Re: Mysql and dynasets

[Patrick Sherrill]

You cannot use dynasets with MyODBC.  The recordset must be of snapshot
type.  If you require dynasets, you will need to create a link table using
MS Access.  Just link to your MyODBC configured database.  MS Access will
wrap Jet around the ODBC driver and provide you the functionality required
for dynasets.

I hope this helps...

Pat...


----- Original Message -----
From: Jones, Benny <Ben@stripped>
To: <myodbc@stripped>
Sent: Monday, November 22, 1999 10:13 AM
Subject: Mysql and dynasets


>
> I'm trying to get an application (EventReader) running on Windows NT to
> update a mysql database on a linux system.  I have myodbc installed, but
I'm
> getting an error message
>
> ODBC error code: 1012
> ODBC driver does not support dynasets
>
> Could someone shed some light on what the problem is?
>
> Thanks much.
>
> Benny Jones
> ben@stripped
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread911@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.
>
>