the problem on oracle database link

Article View: borland.public.cppbuilder.database.ado

Article #3963

Back to borland.public.cppbuilder.database.ado Previous Next

#3963

From: Jiafu Lee
Date: Mon, 29 Apr 2002 11:47

9 lines
1245 bytes

i created a database link "shdc" in my database.when i used the following
script to judge whether the link is valid:
select 1 from dual@shdc
the ORA-02041 error encountered:
 client database did not begin a transaction.
And there's no problem when i using it in the SQL*PLUS.
Why?
Thanks.
jackie

Technical Details

Message-ID: <3ccd332c_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!hub1.nntpserver.com!xmission!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,e6991245b8ddda33,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-04-29 05:00:40 PST
Reply-To: "Jiafu Lee" <themask@163.com>
From: "Jiafu Lee" <themask@163.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: the problem on oracle database link
Date: Mon, 29 Apr 2002 19:47:42 +0800
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 210.21.219.253
Message-ID: <3ccd332c_2@dnews>
X-Trace: dnews 1020080940 210.21.219.253 (29 Apr 2002 04:49:00 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!hub1.nntpserver.com!xmission!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews