OraFAQ Forum: Server Administration » Problem in a Select statement while using Database link

Home » RDBMS Server » Server Administration » Problem in a Select statement while using Database link

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in a Select statement while using Database link [message #370965]

Mon, 17 July 2000 20:10

Suresh.N
Messages: 41
Registered: March 2000

Member

Hi,

I have two database named

1. DB1
2. DB2
I have one user in DB1 database called Jhon.
I have one user in DB2 database is called Allen.

I have created one database link from DB2 to DB1 like

CREATE DATABASE LINK DB1 CONNECT TO Jhon IDENTIFIED BY Jhon USING 'DB1';

I can able to access the values from DB1 by using the Database link from Oracle Sqlplus.

Ex : Select * from Testtable@DB1;

In oracle Sqlplus it is working perfectly.

But if use the same sql select statemnt in Visual Basic, it gives error like

ORA-02041 - Client database did not begin transaction.

I searched the ORA error.It says somthing about XA protocol and Library.

Can u solve this problem

Thanks in Advance
Suresh.N

Report message to a moderator

Previous Topic:	ORA-00206: error in writing (block 1, # blocks 1) of controlfile
Next Topic:	Problem in a Select statement while using Database link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 21:47:43 CST 2025