Skip to main content
Super User

Return to Question

Removed obsolete tag
Link
Burgi
Burgi
  • 6.6k
  • 14
  • 40
  • 52
deleted 11 characters in body
Source Link
Gareth
Gareth
  • 18.9k
  • 15
  • 58
  • 69

I installed Oracle 11g on my Win 7 x64 PC. When I look in Data Sources (under Administrative Tools in the Control Panel) and click on the System DSN tab, I can see the Oracle driver listed ("Oracle in OraClient11g_home1").

The problem, though, is when I try to create a link table in Microsoft Access. I click the 'external data' tab, then click the 'more' drop down and choose "ODBC database". From there I choose "Link to the data source by creating a linked table" and choose the "Machine Data Source" tab on the following dialog window.

From there, I click the 'New' button (to create a new data source) and choose the 'System Data Source' radio button. Now, usually in the resulting list I should be able to see the Oracle 11g data source, but it's not showing up in my list. I'm just wondering if anyone else has run into System DSNs not showing up and what they may have done to remedy the situation.

Thanks!

I installed Oracle 11g on my Win 7 x64 PC. When I look in Data Sources (under Administrative Tools in the Control Panel) and click on the System DSN tab, I can see the Oracle driver listed ("Oracle in OraClient11g_home1").

The problem, though, is when I try to create a link table in Microsoft Access. I click the 'external data' tab, then click the 'more' drop down and choose "ODBC database". From there I choose "Link to the data source by creating a linked table" and choose the "Machine Data Source" tab on the following dialog window.

From there, I click the 'New' button (to create a new data source) and choose the 'System Data Source' radio button. Now, usually in the resulting list I should be able to see the Oracle 11g data source, but it's not showing up in my list. I'm just wondering if anyone else has run into System DSNs not showing up and what they may have done to remedy the situation.

Thanks!

I installed Oracle 11g on my Win 7 x64 PC. When I look in Data Sources (under Administrative Tools in the Control Panel) and click on the System DSN tab, I can see the Oracle driver listed ("Oracle in OraClient11g_home1").

The problem, though, is when I try to create a link table in Microsoft Access. I click the 'external data' tab, then click the 'more' drop down and choose "ODBC database". From there I choose "Link to the data source by creating a linked table" and choose the "Machine Data Source" tab on the following dialog window.

From there, I click the 'New' button (to create a new data source) and choose the 'System Data Source' radio button. Now, usually in the resulting list I should be able to see the Oracle 11g data source, but it's not showing up in my list. I'm just wondering if anyone else has run into System DSNs not showing up and what they may have done to remedy the situation.

Source Link
Kevin
Kevin
  • 165
  • 1
  • 13

Where'd my System DSN that I just added go to?

I installed Oracle 11g on my Win 7 x64 PC. When I look in Data Sources (under Administrative Tools in the Control Panel) and click on the System DSN tab, I can see the Oracle driver listed ("Oracle in OraClient11g_home1").

The problem, though, is when I try to create a link table in Microsoft Access. I click the 'external data' tab, then click the 'more' drop down and choose "ODBC database". From there I choose "Link to the data source by creating a linked table" and choose the "Machine Data Source" tab on the following dialog window.

From there, I click the 'New' button (to create a new data source) and choose the 'System Data Source' radio button. Now, usually in the resulting list I should be able to see the Oracle 11g data source, but it's not showing up in my list. I'm just wondering if anyone else has run into System DSNs not showing up and what they may have done to remedy the situation.

Thanks!