Try using 'snapshot' as your RS type or create an access link table to the
MySQL DB and then use the Jet DB engine in your VC application.
I hope this helps,
Pat...
----- Original Message -----
From: "Craig Burton" <cburton@stripped>
To: <myodbc@stripped>
Sent: Wednesday, September 20, 2000 7:32 AM
Subject: Resend: MyODBC and VC++6 MFC Database Library
> Given the lack of a response, do I assume that nobody else has come
accross
> this problem? Does anybody have any suggestions at all?? I don't really
> want to have to install M$ NT and SQL Server on my server boxes :-(
>
> Cheers,
>
> Craig
>
> -----Original Message-----
> From: Craig Burton [mailto:cburton@stripped]
> Sent: 17 September 2000 12:10
> To: 'myodbc@stripped'
> Subject: MyODBC and VC++6 MFC Database Library
>
>
> Hi,
>
> I am currently having a problem using MyODBC with MS Visual C++ 6 and the
> MFC database libraries.
> My application connects to the MySQL server (on Linux) fine, but when I
try
> to open a CRecordset object, it returns an error:
>
> 'SQLSetPos with lock or refresh is not supported'
>
> Does anyone have any idea what is causing this, and if so, how to get
round
> the problem?
>
> Thanks in advance,
>
> Craig
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential
> and intended solely for the use of the individual to whom
> they are addressed. If you have received this email in error
> please delete it from your system. Any views or opinions
> expressed are solely those of the author and do not
> necessarily represent those of Guernsey Telecoms
>
>
****************************************************************************
****************************************************************
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread2111@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.
>
