I am using Excel 2007 to connect to a local progress database via an add-in. The add-in logs into the DB using the DataDirect ODBC driver for OpenEdge 10.0B...
When I first start Excel, I can log into the DB without any problems. The "Select Data Source" screen is displayed and after I select the odbc driver the "Progress logon" screen (for entering the password) is displayed. This works OK.
If I exit Excel and try again, the connection will fail. After the "Select Data Source" I am not given the chance to enter my password - the progress screen is not displayed. The "OpenDatabase" method in VB fails. Checking the VB source code, I can see that the last error indicates that the user cancelled the operation.
It seems to me that the initial ODBC connection stays active. Is this possible?
Note that in VB debug mode, I can connect every time. Also if I display a message before connecting to the DB, the error also does not occur. The error also does not occur if I use Excel 2003.
Does anybody know what the problem is?
When I first start Excel, I can log into the DB without any problems. The "Select Data Source" screen is displayed and after I select the odbc driver the "Progress logon" screen (for entering the password) is displayed. This works OK.
If I exit Excel and try again, the connection will fail. After the "Select Data Source" I am not given the chance to enter my password - the progress screen is not displayed. The "OpenDatabase" method in VB fails. Checking the VB source code, I can see that the last error indicates that the user cancelled the operation.
It seems to me that the initial ODBC connection stays active. Is this possible?
Note that in VB debug mode, I can connect every time. Also if I display a message before connecting to the DB, the error also does not occur. The error also does not occur if I use Excel 2003.
Does anybody know what the problem is?