I have connected to a DB2 database on our AS400 through SQL Server 2005 (linked server) using the IBMDA400 (OLEDB) provider. However, I recently discovered that I can connect my .Net apps using the IBM.Data.DB2.iSeries.dll provider so I would like to connect to the AS400 using my IBM.Data.DB2.iSeries provider instead. However, the IBM.Da...
I have setup a linked server pointing to an Oracle DB. I want to call a function ABC in a package XYZ passing parameter K. What will be the syntax to do this? ...
Is there any other way to retrieve data from a remote server in SQL Server 2005 instead of using linked server? ...
I was thinking to create something like linked server which i could read data from a remote server using SSIS. My question is, can i do that in SSIS which i will only need to read data from a remote server and join with local server tables in a view! How to do that in SSIS?? Servers i am using are SQL Server 2005. ...
I have created a linked server in SQL Server 2005 to an Oracle DB. When I run a query, The query never stops executing, and never returns results. When I cancel the query, it never completes cancelling. I have to close the window to get it to stop. I have set things up as follows: Installed Oracle Client Tools on SQL Server Ran fol...
I'm trying to use Linq to run queries against a linked server on our SQL Server machine through Visual Studio. On the SQL Server, I've successfully created the linked server and can run queries on it. In Visual Studio I've added a new data connection (under Server Explorer) to the SQL Server with success but the linked server tables are...
Hello everyone, On SQL Server 2000 there is a linked server to an Oracle 9.2 server. I am able to select from the remote tables, but all not latin (Greek) characters, return incorrect. I tried specifying a collation on the SQL Server, but nothing changed. ...
Hi, I am using SQL Server 2008 and I have the following SQL script: Select o.CustomerId as CustomerNoId, OrderValue, OrderDate From dbo.Orders as o Inner Join ( Select Top (10) CustomerId From dbo.Customers where Age < 60 ) As c On c.CustomerId = o.CustomerId This works as desired when used with dbo.Customers and dbo.Orde...
How do I select data from a MS SQL Server from MySQL? We have a system of linked server in SQL Server. I have also heard that you can do a linked server to Mysql from sql server. But I want to know the reverse. The mssql server is what we use mainly for production. So one main reason we'd want to do this is simply to get the exact mssql...
I have a couple of old sql servers with linked servers set up between them. Is there any way from the logs I can figure out when the linked servers were last used by a query (I want to get rid of the linked server) ...
I want to call a sproc on server B from server A in TSQL without linking the servers. Is it possible to use something like a connection string to execute this sproc? The return will be a single nvarchar value. Regards. ...
Hi, I have a SQL server 2000 and an Access database mdb connected by Linked server on the other hand I have a program in c # that updates data in a SQL table (Users) based data base access. When running my program returns the following error message: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed. [...
SQL Server 2008 Linked Server and ad-hoc INSERTs cause a rapid memory leak which eventually causes the server to become non-responsive and ends with the following error: Msg 701, Level 17, State 123, Server BRECK-PC\SQLEXPRESS, Line 2 There is insufficient system memory in resource pool 'internal' to run this query. Location: q...
I found: http://stackoverflow.com/questions/307636/how-do-you-setup-a-linked-server-to-an-oracle-database-on-sql-2000-2005 The DSN tested successfully but after using the stored procedures outlined in the article to create the linked server the 'open query' returned the following message: OLE DB provider "MSDASQL" for linked server "...
I have this code in a trigger. if isnull(@d_email,'') <> isnull(@i_email,'') begin update server2.database2.dbo.Table2 set email = @i_email, where user_id = (select user_id from server2.database2.dbo.Table1 where login = @login) end I would like to update a table on another db server, both are MSSQL. the query above works for m...
Can you please explain how to setup a linked server between a SQL Server (A) and a SQL Server Express (B) scenario. Server A is SQL Server 2000, whereas Server B is SQL Server 2005 Express. I have set these up in the past, but none where connected to a SQL Server Express version. Thanks, Billy ...
Hi there ! I'm trying to query a database view that's not located on the same server as the stored procedure I'm running. I heard about using "linked servers", but I have no access to the server's configuration at all ... Thanks in advance ! ...
I have the following trigger, which causes an error when it runs: CREATE TRIGGER ... ON ... FOR INSERT, UPDATE AS IF UPDATE(STATUS) BEGIN DECLARE @newPrice VARCHAR(50) DECLARE @FILENAME VARCHAR(50) DECLARE @server VARCHAR(50) DECLARE @provider VARCHAR(50) DECLARE @datasrc VARCHAR(50) DECLARE @location VARCHA...
I have 2 SQL 2005 servers SRV1 and SRV2. SRV2 is the linked server on SRV1. I run a storep proc with params on SRV2 and it is completed immediately. But when I run the same proc through the linked server on SRV1, for example EXEC [SRV1].DB_TEST.dbo.p_sample_proc it takes about 8-10 minutes to complete. After restarting SRV2 the problem ...
I currently have multiple queries that query data from a few tables linked through ODBC, and some temporary tables that are edited through the user interface. I have complex criteria in my queries such as: SELECT * from ThingsData WHERE (Thing In(SELECT Thing from ListOfThings) AND getThingFlag() = True); In this case Thing is a field...