List:MySQL ODBC« Previous MessageNext Message »
From:Patrick Sherrill Date:April 25 2000 7:22pm
Subject:Re: Dynasets
View as plain text  
There is no native cursor support in the MyODBC Driver.  Therefore you must
either use 'snapshot' type recordsets in VC++ or create a link file from MS
Access and reference that DSN in your VC++ program.

Pat...
patrick@stripped

----- Original Message -----
From: "James Treworgy" <jamie@stripped>
To: <alberto.ramos@stripped>; <myodbc@stripped>;
<mysql@stripped>
Sent: Tuesday, April 25, 2000 2:19 PM
Subject: RE: Dynasets


> A few things:
>
> Try using ADO instead of DAO (a Dynaset is a DAO recordset type)
> Try using both client side and server side cursors.
> Try changing the options you have selected in MyODBC - generally with MS
> stuff you want only "return matching rows" checked
> Make sure you aren't trying to use ODBC Direct cursors or some such thing
>
> Jamie
>
> At 01:41 PM 4/25/00 -0400, alberto.ramos@stripped wrote:
> >The point is that I am running an application from Visual C++ that uses
> >the recordset class and when I setup the ODBC it pops up:
> >
> >ODBC driver does not support dynasets.
> >
> >I tried the same with SQL server and it worked.
> >
> >Regards,
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread35209@stripped
>
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-patrick=coconet.com@stripped>
>
>

Thread
Dynasetsalberto.ramos25 Apr
  • Re: Dynasetsmiguel sol√≥rzano25 Apr
RE: Dynasetsalberto.ramos25 Apr
  • RE: DynasetsJames Treworgy25 Apr
    • Re: DynasetsPatrick Sherrill25 Apr
  • Re: DynasetsMike Albanese25 Apr