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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

MS Access OBDC to Oracle 11g fails...

752900Feb 10 2010 — edited Jul 14 2011

Attempting to connect MS Access 2003 to a UNIX box Oracle 11g 32-bit database. The Oracle client I'm using is OraClient10gR2.

I can connect when using a pass-through query in MS Access, but can not connect using the MS Access utility “Link Table Manager”.

After approximately 60 seconds of trying to link, the ORA-01013 (cancelled by user) error displays. Of course, I’m not cancelling anything. I have changed MS Access ConnectTimeout value in the registry from the default 600 decimal to 90000 decimal and it still produces the same ORA-01013 error in about 60 seconds.

Please help.
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2011

Added on Feb 10 2010

#general-database-discussions

17 comments

6,263 views