ODBC to connect to SQL performance

[aspfun]

My Access app is using ODBC to connect to SQL server.


Network guy want me do not use ODBC. He said that ODBC will cause network traffic.
Is it true? Is there another way to connect to SQL server other than ODBC?
(like ado.net in visual studio)

[orange]

What options did the Network guy offer you?

[aspfun]

Nothing, he just said that ado.net is better.

[orange]

Well networks are intended to have traffic. You could try Pass through queries written in SQL server sql, that would do processing in SQL server and only pass results back to Access.

I think what he is saying is that you should design your application in a manner that limits the amount of data transfer on the network. Pass through queries, stored procedures etc.

I don't use SQL server, but I'm sure you can Google/Bing and get more specific ideas/examples.

Good luck.