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