In the From ODBC dialog, choose your DSN and click OK. If this is the case please contact your System Administrator. Start Excel and select Data > Get Data > From Other Sources > From ODBC. Depending on your agency’s network and security policies you may not have permission to create/edit ODBC data sources on your computer.
To change the account on the ODBC data source or to edit the configuration settings, follow the Create an ODBC Data Source instructions and instead of adding a new data source you can edit the settings of an existing data source by clicking the Configure button.
EXCEL ODBC MANAGER HOW TO
The following instructions explain how to ensure both your ODBC data source and Excel connections are working correctly and together if a change is required: moving from self-hosted to SaaS, although this should rarely occur). Have you ever connected to SM through an ODBC connection I thought we had this working at once time, but it doesn’t seem to function. The SQL database account that was originally set up to work with these reports needs to be changed.Īthena software has made changes to the server on which your database resides that impacts a configuration setting for connecting to Penelope (e.g. properties > Compatibility tab > Run this program as an administrator is checked and greyed. This would be necessary for the following situations: I have an Excel query that pulls from an ODBC connection. If you have existing Excel workbooks with data connections to your Penelope database there may be a need (on some occasion) to update one or both of the ODBC data sources in Windows and/or data connection/s in Excel. Updating an ODBC Data Source/Excel Connections
0 kommentar(er)
