Home » RDBMS Server » Server Administration » Problem in a Select statement while using Database link
Problem in a Select statement while using Database link [message #369675] Mon, 17 July 2000 20:14
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.
The problem only occurs while using from VISUAL BASIC
Can u solve this problem

Thanks in Advance
Suresh.N
Previous Topic: Problem in a Select statement while using Database link
Next Topic: v$session
Goto Forum:
  


Current Time: Sat Oct 24 04:25:38 CDT 2020