View Complete Post
I'm doing a simple data load between two linked servers, and everything is working fine until I include an UPDATE statement, that's when I receive the following error message.
OLE DB provider "SQLNCLI10" for linked server "ServerName" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 28
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "ServerName" was unable to begin a distributed transaction.
DECLARE @TempTable TABLE(PDID INT
I have installed Sybase 12.5.1 OLE DB Driver and have also registered by running
We are also able to create System DSN from ODBC Administrator in Windows 7. I am
also able to import data in the MS Access. Here is the System DSN I created, successfully.
I would really appreciate you can help us out.
I have two instance of database and connected the other with linked server. When i run the application locally its working fine. It gets valur from linked server tables. After hosting the application in IIS im getting following eror.
The OLE DB provider "SQLNCLI" for linked server "LINK" does not contain the table ""90"."dbo"."table"". The table either does not exist or the current user does not have permissions on that table.
Can anyone specify what user should be mapped to solve this issue?
I have hosted my application in IIS. Application has two instance of sql server database connected through linked server. After hosting the aplicaiton in IIS im getting the following error.
SCHEMA LOCK permission denied on object.
Can anyone help?
In an effort to do some testing prior to upgrading our environment to 2008 R2, I made a test instance on our Dev box. 2005 instance, copied as many things as I could think of from various other instances. Made a basic linked server to our main
cluster, had a repeating job to email me results of a query across that link every few hours.
Everything was working fine until the upgrade finished. It completed at ~7pm. The email at 6PM came through fine (while the upgrade was in progress), the email at 8pm didn't come through. Checked various things (DB mail was still working,
tested fine). It couldn't access the data across the linked server. I tried deleting that link and remaking it. Errors out. Tried running the same scripts we use to create our standard linked servers, error out. The only ones
that I can set up and function are links to other instances on the same box.
I've looked around at other fixes for this error message and none seem to make any difference. Log in with Domain cred's, log in with the sa account, no difference. I can connect from other instances & servers back to this one, just not outbound
from this one. And it worked prior to the upgrade I applied to it. All other instances on the box are 2005 as well.
Here is the message I ge
I have been using SQL 2005 successfully to connect to tables in a 10g Oracle data warehouse. I have been using the 11g client.
I have tried several times to get this working in SQL Server 2008 (and R2) and have tried the 10g and 11g clients...
I do a query like Select top 100 * from DWD..DW.IC_TRAN_PND and I get the error:
"Invalid data for type "numeric".
I have read about the reasons for this but is there a way to make it work like it does in SQL server 2005?
Here's the situation.
I have a SQL 2008 box (with latest updates...ver 10.0.4279.0) where I've created a linked server to DB2 ver 9.5 on linux.
I have a local windows group of users who are sysadmins on the SQL Server, but not Administrators on Windows. Also, the SQL Server & Agent service are running as Windows Administrators. (this is a dev box).
Here's the simple code I used to create the linked server:
EXEC master.dbo.sp_addlinkedserver @server = N'DB2BOX', @srvproduct=N'MDASQL', @provider=N'MSDASQL', @datasrc=N'DB2MACHINENAME', @location=N'System', @provstr=N'Provider=MSDASQL.1;Password=xxxxxx;Persist Security Info=True;User ID=db2userid;Data Source=DB2MACHINENAME'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2BOX',@useself=N'False',@locallogin=
I am trying to create a linked server from sql server 2008 to a secure access 2003 database(database which has a password), whatever options i am trying the result is i am getting the error 7399("Cannot start your application.
The workgroup information file is missing or opened exclusively by another user.".)
or error 7303.
I am selecting 'Microsoft.Jet.Oledb.4.0' as the provider. I think the problem is somewhere in
the workgroup files
Please help me in creating this linked server.
The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.
Word Automation in sample ASP.NET(C#) application.
I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.
When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.
But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.
Data: System.Collections.ListDictionaryInternalMessage: Word has encountered a problem.Source: Microsoft Word
The code gets failed in the following line:
ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line
I cannot able to proceed further. Can anybody please help me in solving this issue?
when i open my sql database in webmatrix then i got this error. i already install sql server 2008 r2 and he work fine everywhere in my system.
how i can solve this issue.
I'm tried SELECT * INTO XXX FROM OPENROWSET alongwith Microsoft.ACE.OLEDB.12.0.
Apparently the query requires the sql account to have SYSADMIN privileges.
Considering that SYSADMIN should not be provided to a database account on a Production Server, I tried using the Linked Server method.
Following is my code.
Exec sp_addlinkedserver 'AB2','Ace 12.0','Microsoft.ACE.OLEDB.12.0','\\126.96.36.199\sagarr\Test1\cpc\c2\AB2.xlsx',NULL,'Excel 12.0;IMEX=1'Exec sp_addlinkedsrvlogin 'AB2','false',NULL,NULL,NULLgoSELECT * INTO [CPCAB2.xlsx] FROM OPENQUERY([AB2] ,'SELECT * FROM [Sheet1$]')Exec sp_dropserver 'AB2','droplogins'
Now i get the following error
Error.15247-User does not have permission to perform this action
My Excel file, Database and Windows Application run on separate machines.
i have provided the following privileges
GRANT ALTER ANY LOGIN TO sqlaccountGRANT ALTER ANY LINKED SERVER TO sqlaccountEXEC sp_configure 'show advanced options', 1RECONFIGUREEXEC sp_configure 'ad hoc distributed queries', 1RECONFIGUREThe DisAllowAdHocProcess in