Here is an example of using a script rather than the ODBC dialogue box to link to SQL Server. It is not really the connection tool, it is how the connection is used. If you build a View on SQL Server or create a PassThroughQuery on Access - the question goes to SQL, sorts things out and returns the answer. If you just have linked tables - a query can pull all the data over the network to the client to sort things out, just to get a record or two. What he might be talking about is setting up a parameter query on SQL Server. I don't like ODBC because it can require going to each PC to set up ODBC. ODBC won't cause more than other methods including ado.net. One would expect a Network to have traffic. If the database is a split DB (a front-end application - linked to a back end data store on the network) it will cause network traffic.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |