Page 1 of 1
Get data over Oracle database link
Posted: Tue 26 Feb 2013 08:41
by Sergo80
I am trying to use TUniQuery with Oracle database link (link is over ODBC to SQL Server). I have active UNI connection and active database link in database, sql is "select * from A0_Workers@dblink" (dblink is database link to SQL server), but when trying to set query active, it stops responding?
Same sql works fine with sqldeveloper.
Do i need to set some other settings? Or it doesnt support database links?
Re: Get data over Oracle database link
Posted: Tue 26 Feb 2013 11:57
by AlexP
Hello,
We cannot reproduce the problem, UniDAC works correctly - it opens queries that use ODBC dblink to a remote SQL Server. Please specify the exact versions of:
- Oracle client and server;
- SQL Server client, server, and ODBC driver;
Re: Get data over Oracle database link
Posted: Tue 26 Feb 2013 12:18
by Sergo80
Oracle client and server: 10g
SQL Server client, server, and ODBC driver: Sql Server 2008
IDE: Delphi 2007
UniDAC: 2.50
Re: Get data over Oracle database link
Posted: Tue 26 Feb 2013 12:37
by AlexP
Hello,
You use a pretty old version of UniDAC . Please check your application on the new UniDAC version 4.6.12
Re: Get data over Oracle database link
Posted: Tue 26 Feb 2013 13:03
by Sergo80
Tried with newer version, same result. I am using in SpecificOptions Direct=true. Can this be the problem?
Re: Get data over Oracle database link
Posted: Tue 26 Feb 2013 13:13
by Sergo80
Just test it. If Direct=true it doesnt work, with Direct=false, it works. But i need it works with Direct=true.
Re: Get data over Oracle database link
Posted: Tue 26 Feb 2013 15:17
by AlexP
Hello,
The problem may be due to the data types used in the table, or due to the data, since links work with SQL Server with no problems on our test servers independently on the Direct option. Please send us the script for creating the table or the dump of the table to alexp*devar*com
Re: Get data over Oracle database link
Posted: Wed 27 Feb 2013 07:25
by Sergo80
The problem is, when Direct=true and using Database Gateway for MS SQL Server (DG4MSQL), not Database Gateway for ODBC. I have two listener set up, and first thought it is ODBC not working, but it is DG4MSQL. Can you check with DG4MSQL?
Re: Get data over Oracle database link
Posted: Wed 27 Feb 2013 14:21
by AlexP
Hello,
We have checked work in the Direct mode on Oracle Database Gateway for MS SQL Server (DG4MSQL), and we still cannot reproduce the problem. Please send the script or the dump of the table, which opening causes problems.
Re: Get data over Oracle database link
Posted: Mon 04 Mar 2013 15:01
by AlexP
Hello,
Thank you for the information. We have reproduced the problem, and we will try to fix it in the next version. We will inform you as soon as we have any results.