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



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