microsoft.public.sqlserver.programming - Microsoft SQL Server
Hi, I,m running this update query with linked server from SQL Server 2005 64 to Oracle 10.2 update MSORACLE1W..ORAS_USER.THISLOG set TRANS = 1 and get this error Cannot fetch a row using a bookmark from OLE DB provider "OraOLEDB.Oracle" for linked server Anyone? Thanks D.
Hi All, I have a problem when trying to execute an OPENDATASOURCE query between 2 SQL Server, One of them is SQL 2000 (32 bit) 8.00.2282, and the other is SQL 2005 (64 bit) 9.00.4035. an error is appeared "Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "(null)". The provider supports the interface, but returns a failure code when it is used." I do not use linked server, just opendatasource is enough for me. All forum concentrate on that sql 2000 does not applied to SP3 or later. but for my case not sp4 is applied for sql 2000. Can anyone point me to the right direction ???? Thanks in advance,,,
I have a problem when executing insert statement that executes from different server. Here are the details: Table A --> Belongs to Server 1 Table B --> Belongs to Server 2 Table C --> Belongs to Server 3 I'm inserting records in table B using the following query: Insert into C Select * From A Where colA not in (Select colB From B) I'm getting the following error : The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ] Main thing is MS DTC service cannot be enabled in the Server2. Please advise.