List:MySQL ODBC« Previous MessageNext Message »
From:Patrick Sherrill Date:November 22 1999 3:32pm
Subject:Re: Mysql and dynasets
View as plain text  
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...


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

Mysql and dynasetsBenny Jones22 Nov
  • Re: Mysql and dynasetsPatrick Sherrill22 Nov