I want to connect SAS with MS SQL server database. I found that if I use PROVIDER =SQLOLEDB then SQL date column is read as char in SAS.
If I use PROVIDER=SQLNCI10.1 then SAS read SQL date column as SAS date.
Refer to http://support.sas.com/kb/39/188.html
My question - what is this PROVIDER=SQLNCI10.1 option is doing that makes SAS to read SQL date as date correctly?
What are other difference would be there if i use PROVIDER=SQLNCI10.1 instead of PROVIDER =SQLOLEDB?