MS Access 07 ODBC Oracle 10g Express
730054Oct 26 2009 — edited Nov 6 2009Hi guys, spend a lot of time searching forums on how to connect Oracle with ODBC from Access and I am having trouble connecting.
Oracle 10g Express installed locally with static IP 192.168.1.2 with system name AnabolicPC but oracle control database html links to 127.0.0.1:8080 which works fine (loopback address)
So here's what I do:
Open Access 07, btw Oracle 10g Express running and I can login and type commands in SQL Worksheet no probs.
After that I click on External Data in Access then more>ODBC Database>Link to Data Source by creating a linked table (have to click that, part of a tutorial I have to do at uni)> click OK and
Select Data Source appears>then I select Machine Data Source> New> System Data Source> then from the list I select Oracle in XE> Next> Finish> Now I checked tnsnames.ora and XE seems right:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = AnabolicPC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
But I cannot connect to it, I consulted ODBC Oracle help and followed instructions but still doesn't work. Vista x64 btw. The error I get is ODBC call failed.
Any help would be appreciated. Can't make any sense of other posts. I'm a newbie so step by step solution would be great.
Thank you in advance
George