Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    7

    Unanswered: Linked Server Problem

    Hi!

    I have written a Perl Program, which works on a MS SQL SERVER 2000 database. It should import some data from an Oracle8i database. so i created a linked server and a linked server login. There were no problems when i created these things. But if i execute a "select ..."-Statement at the linked server(Oracle), i get the following message:

    "[Microsoft][ODBC SQL Server Driver][SQL Server]Die Operation konnte nicht ausgeführt werden, da der OLE DB-Provider 'MSDAORA' keine verteilte Transaktion beginnen konnte. (SQL-42000)
    [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB-Fehlertrace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b]. (SQL-01000)(DBD: st_execute/SQLExecute err=-1),ERROR = -1"

    But the select statement, i used is ok. i started it in the Query Analyzer and everything was fine! This is the statement:

    "select * from openquery(SRCLINKWORLD,'SELECT COUNT(*) AS ANZAHL FROM DBADMIN.ABSCHLUSSABR')"

    Does anyone know , what the problem is???

    Nick

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well....I know very little German (it is German isn't it), but what login did you use to connect with?

    Is it a remote login in Oracle?

    This is purely a shot in the dark...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Posts
    199
    Strange SELECT you use,

    why

    "select * from openquery(SRCLINKWORLD,'SELECT COUNT(*) AS ANZAHL FROM DBADMIN.ABSCHLUSSABR')"

    instead of

    SELECT COUNT(*) AS ANZAHL FROM DBADMIN.ABSCHLUSSABR

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •