Oracle to Access ODBC drivers on XP
Posted on 2006-03-20
I'm trying to connect My database to an Oracle database, but don't fully understand what I'm doing. I have NO knowledge of Oracle (and no permissions) - I will need to ask a distant and unhelpful IT department if anthing needs to be checked/sorted at the Oracle end. This is on XP with Access2003
I have downloaded and installed
This has given me
Microsoft ODBC for Oracle MSORCL32.dll
Then in the Systen DNS tab I have added the above driver and this has given me a set of options
Data Source Name
I don't know what to put here, or what to ask the IT department.
On an older version of Access on an older machine, we connected to Oracle using an Oracle73 Ver2.5 driver
This had a different set of options:
This had an Oracle connect string of TNS:CFDB
but no server name is mentioned.
Please could someone give me some advice, or if I am short of information, what specifically to ask the IT department?