Linked server UPDATE fails with message about optimistic concurrency ...
Oct 20, 2020 · The same UPDATE queries that fails through the linked server works fine through the same DSN, using VBScript. The UPDATES fail when running them from a stored procedure or SQL …
SqlServer->MySQL Linked Server: was unable to begin a distributed ...
Sep 23, 2016 · OLE DB provider "MSDASQL" for linked server "MYSQL" returned message " [MySQL] [ODBC 5.3 (w) Driver]Optional feature not supported".Msg 7391, Level 16, State 2, Procedure …
can I access function on remote server through linked server?
Dec 14, 2010 · How can I execute a user defined function on remote server through linked server?
does support SQL Server link server along with port number?
Dec 19, 2016 · If you use an alias you would put the port in the alias and not in your linked server. Can you do this from the source server. In a command prompt with elevated permissions go to …
Linked Server to IBM iSeries - social.msdn.microsoft.com
May 8, 2019 · The linked server is configured to use a common login to connect to the iSeries. The OLE DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem …
Using Linked SQL server in a View - social.msdn.microsoft.com
Mar 3, 2015 · I have a new view that reads data from the base source server/table. Also, it links in another server (using the sp_addlinkedserver command).
SQL 2008 R2 SP1 : Crashing On Linked Server Query
Nov 11, 2011 · Ran the linked sql in Management Studio - boom got the result --> Hard Work Always Pays Ran the same sql in client side - CRASH and Sql Dump ---> But not in case of MS Surprisingly …
Linked server is working from SSMS but not from Execute SQL Task in …
Oct 5, 2016 · If the linked server is configured to connect with "Be made using the login's current security context" and not with "Be made using this security context" then it will attempt to connect …
Linked Server Synonym/ Alias - social.msdn.microsoft.com
Feb 19, 2017 · here the linked server is pointing to a database called 'abc'. My goal is to restore a backup of this database in the test environment. However if I run the same query in test it will fail, …
Linked server using ASEOLEDB - social.msdn.microsoft.com
Apr 3, 2015 · Has anyone managed to get a linked server working between SQL 2008R2 and Sybase ASE 15.7 using the SAP/Sybase OLE DB driver and not using an ODBC DSN?