>>Hi all,
>>
>>Is it possible to use the SQL OLEDB provider (instead of ODBC) for remote views or SPT?
>>
>>
>>if possible
>> how?
>>else
>> why not?
>>endif
>>
>>
>>Thanks,
>
>This may help
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxtk00/html/ft00l1.aspEric,
Thanks for the link. I'm already using (rather, learning) ADO with SQL OLEDB provider. I'm in the process of exploring my other options for getting to SQL Server data. It seems that remote views and SQL pass-through are mentioned more often around here than ADO, so I am checking those 2 routes out.
As far as I can tell, you have to use an ODBC connection (not OLEDB provider) to use RV or SPT.
Steve Gibson