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
If it's not broken, fix it until it is.
My Blog