Home » RDBMS Server » Server Administration » Problem in a Select statement while using Database link
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
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:
  


Current Time: Fri Mar 29 04:10:35 CDT 2024