Tag Info

New answers tagged

0

You can see the information how SQL tables are linked. Keep the mouse pointer on the link table. You can see all the information like DSN = (Data Source Name) Name of the connection UID = UserID APP = Applicaton DATABASE = name of the database in which the linked table is available NETWORK = SQL Server network protocol ADDRESS = Server IP,Port TABLE = ...


5

If the SQL server table is modified will it be automatically reflected in the [linked] table and when? Yes, on next refresh or requery. If I edit the linked Access table will it be reflected in the SQL server table? Yes; as before, these updates will be visible on the other end on next refresh or requery. Trusted Connection only controls how the connection ...


1

Why not just use the SQLNCLI10 provider? Are you required to use MSDASQL? Here is a sp_addlinkedserver script adding a linked server named ServerST that points to ServerAR. EXEC master.dbo.sp_addlinkedserver @server = N'ServerST', @srvproduct=N'ServerST', @provider=N'SQLNCLI10', @datasrc=N'ServerAR' Update 19/082014 Download SQL Query Stress Tool ...



Top 50 recent answers are included