Skip to Main Content

DevOps, CI/CD and Automation

MS Access 07 ODBC Oracle 10g Express

730054Oct 26 2009 — edited Nov 6 2009
Hi 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 with system name AnabolicPC but oracle control database html links to 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 =
(ADDRESS = (PROTOCOL = TCP)(HOST = AnabolicPC)(PORT = 1521))
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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2009
Added on Oct 26 2009