>>>what type shall i use in QLserver2008 for VFP memo fields i tried varchar(MAX) but it does not seem to accept carriage returns when entered in SSMS
>>>
>>>
>>>Peter
>>
>>Don't enter values manually in SSMS. Use UPDATE command or INSERT command.
>>
>>Varchar(max) is the correct type to use.
>
>
>I am brand new to this.
>
>how do I connect to my local SQLserver 9i used all defaults on install) from VFp??
>
>thnaks
>
>
>Peter

We're using DSN we have created and SPT. The connection is established once in the init of the application object (using SQLConnect command) and then using this connection handle saved in the application object property we send SQLExec commands.