Kbase P180517: How to connect 32 bit MS Excel 2010 to 32 bit OpenEdge database with ODBC on 64 bit Windows
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/21/2011 |
|
Status: Unverified
GOAL:
How to connect 32 bit MS Excel 2010 to 32 bit OpenEdge database with ODBC on 64 bit Windows
GOAL:
ODBC connection with 32 bit MS Excel 2010 to 32 bit OpenEdge database on 64 bit Windows
FACT(s) (Environment):
Windows 7
Windows Vista
OpenEdge
MS Office 2010 32 bit
FIX:
First start the 32 bit ODBC manager from C:\Windows\SysWOW64\odbcad32.exe, then go to the tab 'File DSN' and click on 'Add...', select 'Progress OpenEdge 10.x Driver' and click 'Next', and fill in a name for the data source file, for example 'testdb' and click on 'Next' followed by 'Finish'. In the 'General' tab fill in the following information 'Description', 'Host Name', 'Port Number', 'Database Name', 'User ID' and test by clicking on 'Test Connect' that the connection works (the message 'Connection established!' should appear). Save the settings by clicking on 'Apply' and 'OK', in the tab 'File DSN' of the 32 bit ODBC manager a new 'testdb' file DSN should appear. The DSN file will probably be stored in C:\Users\UserName\Documents
To import data in Excel using this DSN file it will be necessary inside Excel 2010 to go to the tab 'Data' , and to click on the icon 'Existing Connections' and 'Browse for More...' and to select the freshly made 'testdb' file to be able to connect to the database and to select the right OpenEdge database table to import in Excel.