by Hi this is a thread from another news group that has not been
answered. Any ideas anyone?
Thank You, Thank You...you hit it right on the money. It seems SQL
import/export converted all my MS-Access memo fields to the SQL ntext
data type. Does SQL Server have a comparable memo field type? If not
how do people get around the memo field requirement? Create text field
large enough for the average requirement?
Thanks Again
On Thu, 17 Jun 1999 16:40:30 +0400, Alexey Dolganov
>Hi John!
>Your data (at least one column in the table you are quering) imported into
>MS SQL as Unicode text (ntext datatype). So you cannot request the data
>using DBLibrary.
>To avoid this problem you should first change column datatype from ntext
>to text, if you really don't want to use unicode.
>Other workaround is to use osql instead of isql and newer ODBC drivers
>Regards,
>Alexey Dolganov,
>MCP,
>Moscow, Russia