[sqr-users] Error with linked Server only in SQR not in SQL Analyzer

[Scotty Barnes <sculleyminded@yahoo.com>]

I am trying to select data from a table in a SQL Server 
database 7 from 2000.  Our DBA set up a database link 
sp_addlinkedserver.   I can select data using SQL 
Analyzer from either database pointing to the other.  
But if I run an SQR using the same SQL statements I get an 
error I don’t know how to resolve.  We tried reseting the 
RPC as the Microsoft site recommended with this error, 
but it did not help the SQR.

 

If I add the connect string to the select statement I am 
able to connect to the database.  But I want to connect 
using the link set up with the sp_addlinkedserver b/c I 
want to call functions and stored procedure saved in the 
database that take advantage of the
 link.

 

 

BEGIN-select -DB'DSN=database;UID=user;PWD=pw'

 

Any Ideas?  See more details below.

 

Scotty

 

 

 

 
   
   
   
  SQR for PeopleSoft/8.47/PC/Windows NT/ODBC/Sep 20 2005
   
   
  There errors look like this:
  This error is ok
  Warning:  DROP TABLE SCOTTY_TEMP 
  Error:  [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 
'SCOTTY_TEMP', because it does not exist in the system catalog.
   
  This is from  the begin-setup section
  Warning:  SELECT EMPLID, NAME, LAST_NAME_SRCH FIRST_NAME_SRCH  , NAME_PREFIX,
    NAME_SUFFIX INTO SCOTTY_TEMP FROM
    PS8DEVDB.FSDEV.dbo.PS_PERSONAL_DATA 
  Error:  [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider 
returned message: New transaction cannot enlist in the specified transaction 
coordinator. ]
   
   
  STATRING PROGRAM
  (SQR 5528) ODBC SQL dbexec: SQLExecute error 7312 in cursor 3:
     [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned 
message: New transaction cannot enlist in the specified transaction 
coordinator. ]
  (SQR 5528) ODBC SQL dbexec: SQLExecute error 7300 in cursor 3:
     [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error  trace [OLE/DB 
Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
  (SQR 5528) ODBC SQL dbexec: SQLExecute error 7391 in cursor 3:
     [Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be 
performed because the OLE DB provider 'SQLOLEDB' was unable to begin a 
distributed transaction.
   
  Error on line 19:
     (SQR 3723) Problem executing cursor.
   
  SQR: Program Aborting.
   
   
   
  BEGIN-SETUP
  BEGIN-SQL ON-ERROR=WARN
  DROP TABLE SCOTTY_TEMP
  END-SQL
  BEGIN-SQL ON-ERROR=WARN
    SELECT EMPLID, NAME, LAST_NAME_SRCH    
   FIRST_NAME_SRCH     , NAME_PREFIX,
  NAME_SUFFIX
  INTO SCOTTY_TEMP FROM DEVDATA.M9500.dbo.PS_PERSONAL_DATA
   
  END-SQL
  END-SETUP
   
   
  begin-program
   
  SHOW 'STATRING PROGRAM'
  BEGIN-select LOOPS=2
  NAME
   SHOW &NAME
  FROM DEVDATA.M9500.dbo.PS_PERSONAL_DATA
  END-SELECT
   
  SHOW 'ENDING PROGRAM'
  END-PROGRAM
   
  [] 
  [] Thanks,
  []Scott
  [] 
  

 
---------------------------------
 Scott A. Barnes
 73-20 Yellowstone Blvd
 Forest Hills, NY 11375 
---------------------------------
 
 Lottery: A tax on people who are bad at math!
  
   

---------------------------------
Cheap Talk? Check out Yahoo! Messenger's low  PC-to-Phone call rates. 



---------------------------------
Scott A. Barnes
73-20 Yellowstone Blvd
Forest Hills, NY 11375
---------------------------------

Lottery: A tax on people who are bad at math!
 

 
---------------------------------
Sponsored Link

Get a free Motorola Razr! Today Only! Choose Cingular, Sprint, Verizon, Alltel, 
or T-Mobile.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users