If this is the case please contact your System Administrator. 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 Driver: ODBC Driver for Excel - CData Software Excel ODBC Driver Read, Write, and Update Excel through ODBC Easily connect live Microsoft Excel data with BI, ETL, Reporting, & Custom Apps. ![]() 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). 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. ![]() This would be necessary for the following situations: 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 Comments
Leave a Reply. |