![]() If it is not, an installer may be downloaded from Microsoft for the Excel ODBC driver. This is usually installed with a Microsoft Office installation. The Excel ODBC driver must be installed on each QuerySurge Agent box, because the Agent uses a JDBC-ODBC bridge to connect to the files through this driver.If you need to change the user login under which the QuerySurge Agent is running, see: Setting an Agent to Run Under a Specific Login This is especially important to verify if the directory is a network share directory, however it may be important even for local directories. The user login under which the QuerySurge Agent is running must have access to the directory path in which your Excel files are located, and minimally must have Read permissions for the directory.If you haven't already, you should convert all Excel Connections to use the QuerySurge Excel JDBC Driver. Note: The option to create new Excel Connections via Java's builtin ODBC/JDBC is deprecated in QuerySurge version 9.0+. The current date for sunset of backwards-compatibility is October 31, 2019. While QuerySurge 6.4 is backwards-compatible for your existing Excel queries, you should start planning to move your existing queries to the QuerySurge Excel JDBC Driver. Note: Connection to Excel via Java's builtin ODBC/JDBC bridge feature (on which this connection depends) is being deprecated starting with the QuerySurge 6.4 release, since Java has removed the bridge feature. Details for connecting with the QuerySurge JDBC Driver for Excel are available in this article. Users are strongly urged to use this all-Java JDBC driver for Excel data, as Java's JDBC/ODBC bridge has been removed in Java 8 and above. ![]() Since QuerySurge 6.3, QuerySurge has shipped with its own proprietary JDBC driver for Excel. T his article describes the setup for this JDBC/ODBC bridge-based approach. Note : QuerySurge 6.3 and below connect to Excel using Java's built-in JDBC/ODBC bridge along with the Microsoft's Excel ODBC driver. ![]() Versions: 8.0+ QuerySurgeâ„¢ Setup for Microsoft Excelâ„¢ ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |