I am trying to link Oracle 11g tables to Microsoft access 2010, But I keep getting the odbc --call failed error.
Here are my steps:
- Click on External Data tab, then go to ODBC Database.
- Check "Link to the data source by creating a linked table".
- Go to the "Machine Data Source" tab
- Create a new Data source -> System Data Source -> Select Microsoft ODBC for Oracle, then finish
- Data Source Name: TestODBC Description: Testing Username: Test Server: TestServer
The value of Test Server is already created in the tnsnames file. I've ran a tnsping on it and it works. I'm not sure what's going on. Please advise.