Kbase P143845: MS Excel 2007 prompts for password despite the ODBC File DSN containing the Password
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/04/2009 |
|
Status: Unverified
SYMPTOM(s):
MS Excel 2007 prompts for password despite the ODBC File DSN containing the Password
The password is not asked the first time the data is imported into MS Excel
The password is prompted when refreshing the MS Excel spreadsheet
This only occurs with Office 2007 (MS Access 2007, MS Excel 2007)
FACT(s) (Environment):
Windows
OpenEdge 10.x
FIX:
Save the password in the connection string of the ODBC connection in the MS Excel spreadsheet.
After selecting the ODBC File DSN and saved the Excel spreadsheet, the following steps have to be followed:
- Click on the "Data" menu
- Select the "Connections" item which should open a "Workbook Connections" dialog-box.
- Select the query and click on the "Properties" button
- In the "Connection Properties" dialog-box, click on the "Definition" tab.
- Check the "Save password" checkbox.
The password will be added in the Connection string.
For example:
DRIVER={Progress OpenEdge 10.1B driver};UID=ODBC_TEST;PWD=PWD_TEST;DB=sports2000;PORT=9999;HOST=localhost