You may want to check

Re: Varchar(MAX), Memo fields, SPT and Remote Views Thread #1284904

Re: Microsoft sql server compact edition oledb provider Thread #1382195

Re: CursorAdapters and VARCHAR(MAX) columns in SQL Thread #1321461 Message #1321808

>Hi all
>
>May I know the difference between the following options for connection string
>
>lnConn =SQLSTRINGCONNECT('DRIVER=SQL Server;DATABASE= ....
>
>versus
>
>lnConn =SQLSTRINGCONNECT('DRIVER=SQL Native Client;DATABASE= ....
>
>I have problems using the 1st one with DB Encryption.
>
>Switching to the 2nd version solves the DB encryption problem but the second version cannot recognise the newer data types such as varchar(max) in SQL2005
>
>Your advice much appreciated.
>
>Thanks & Best Regards