> >
> > hi
> > I have this problem also and I am using vfp6
> > you need to install the latest odbc connector 5.1 and then you need to set a flag called
> > "LIMIT column size to signed 32-bit range" to check (even if it sound like it the opposite)
> > this flag can be found when clicking Details button on tab "Flag 3"
> > you also can check the flag "allow big results set" on tab "Flag 1"
> > that works for me.
> > you can also take a look here:
> > "Wrong field type for longtext is returned to Visual Foxpro, data are truncated"
> > http://bugs.mysql.com/bug.php?id=30890
> >
> > barak
>
> Barak,
> Thanks a lot, that did it. Have now installed 5.1 and checked the flag on tab3. My rating for you.
> Shalom.
> Koen

thanks
also FYI there is a way doing that in a dsnless way:
the option number of that Flag is : 134217728
when browsing the LONGTEXT field becomes a Memo field
example:

lcServer=myServername &&or server ip
lcDatabase=mydbname
lcUser = myusername
lcPassword = mypassword
lcStringConn="Driver={MySQL ODBC 5.1 Driver};Port=3306;option=134217728"+;
             ";Server="+lcServer+;
             ";Database="+lcDatabase+;
             ";Uid="+lcUser+;
             ";Pwd="+lcPassWord
*** Don't prompt for login
SQLSETPROP(0,"DispLogin",3)

lnHandle=SQLSTRINGCONNECT(lcStringConn)
IF lnHandle  > 0
      
   SQLEXEC(lnHandle  , "select * from atable","curTemp")
   brow
      
   SQLDISCONNECT(lnHandle)
ELSE
   =AERROR(laError)
   MESSAGEBOX("Error at Connecting"+CHR(13)+;
              "Description:"+laError[2])
ENDIF

barak