> >
> > 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
>
>
>
> Barak Hi,
>
> Little bit difficult at this moment to try out your DSNless way, since I would than have to get rid of my present fine working installation, shall try it in a few days on an other machine. Just out of curiosity, where did you find this DSNless solution optionnumber? And do you also have such a solution at hand for 3.51?
>
> Regards,
>
> Koen

Hi

I was looking for "LIMIT column size to signed 32-bit range" + mysql in google.
I got to a c file that defines this flag.

it will not work with 3.51 since they fixed the bug in 5.0 I think
but I tested it just in case and it did not work

so 5.1 is the solution


Barak