Get data over Oracle database link

[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?

[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;

• IDE;

• UniDAC.

[Sergo80]

Oracle client and server: 10g
SQL Server client, server, and ODBC driver: Sql Server 2008
IDE: Delphi 2007
UniDAC: 2.50

[AlexP]

Hello,

You use a pretty old version of UniDAC . Please check your application on the new UniDAC version 4.6.12

[Sergo80]

Tried with newer version, same result. I am using in SpecificOptions Direct=true. Can this be the problem?

[Sergo80]

Just test it. If Direct=true it doesnt work, with Direct=false, it works. But i need it works with Direct=true.

[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

[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?

[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.

[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.