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 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 4 2009
Added on Oct 26 2009
2 comments
3,566 views