Tim ----

Sorry --- Forgot to address the rest of your question:

It's going to be far easier to create a remote view to manage server data with the View Designer in a database, then to use SQLEXEC and manually set cursor properties.


>
>For General datatypes, try using an image datatype in SQL Server. Varbinary and Binary datatypes won't work as they are limited to 255 bytes.
>
>
>>How can I do this.
>>
>>I am guessing a foxpro table type of general.
>>Maps to varbinary in SQLServer but that's all I know.
>>
>>How can I use ODBC..SQLEXEC to upload data in a general field to
>>the SQLServer.
>>
>>Thanks