Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dg4odbc problems

928143Apr 3 2012 — edited Apr 3 2012
Hello,
I've a problem with a external database link. The scenario is:
W2008 server
Oracle 11g 11.2.0.3.0
System ODBC entry using Microsoft Access Driver(*.mdb) pointing to mdb file.
Database Link using previous odbc.

If I perform any Select from a external table, works fine. But if I try a select count(*) from <external_table>@<database_link> where <date_column> > to_date(...) the query never ends. The external table have datatype long fields.

In previous versions of Oracle worked fine, also in 11g installed over other Operating System; even 11g64.

Any Idea?

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2012
Added on Apr 3 2012
#11g, #heterogeneous-connectivity, #odbc
11 comments
1,424 views