September 30, 2011 at 6:39 am
When data is accessed on a remote SQL Server via a DSN connection, is the data viewed 'in situ' or is it effectively transferred to the local network?
September 30, 2011 at 8:06 am
What do you mean with "data"?
Just the records you selected? Yes, they are transferred as TDS packets.
The whole table? No, it is not transferred, unless the application does things very inefficiently.
-- Gianluca Sartori
September 30, 2011 at 8:07 am
nwalker 82762 (9/30/2011)
When data is accessed on a remote SQL Server via a DSN connection, is the data viewed 'in situ' or is it effectively transferred to the local network?
I am not sure what a DSN connection has to do with how the data is viewed. That is more of a question as to how your are querying the data. If the machine you are on in not the database server then the data is passed over the network to your application that is querying the data.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply