Forum Stats

  • 3,874,381 Users
  • 2,266,757 Discussions
  • 7,911,832 Comments

Discussions

ODBC to oracle 11g from MSaccess2003

676566
676566 Member Posts: 1
edited Dec 20, 2008 4:52AM in Heterogeneous Connectivity
I am trying now since several days, to connect through ODBC from MS access to oracle 11g.
Oracle 11g 64x installed on Windows Vista Business 64x
MS Access 2003 with latest service pack
Defined a odbc connection, test option ok with oracle supplied odbc driver, but from access, no way to connect
ODBC call failed no data source
then i tried to use the supplied MS driver, but it does not work either.
From sqldeveloper i could connect without any problems to access db.
Any idea how to solve?
Tagged:

Answers

  • Kgronau-Oracle
    Kgronau-Oracle Posts: 2,550 Employee
    This form is for heterogeneous connections from an Oracle database to a foreign database (like MS Access) with an Oracle database as the driving site.
    You want to connect from a MS Access database to Oracle using an ODBC driver which is handled in this forum:
    3147
This discussion has been closed.