Q: Why can I execute queries in Excel when I have not enabled Data Connections?
A: This is a feature of Microsoft Excel. As long as you have successfully logged into the NoetixViews account in the spreadsheet, Excel can refresh the data without having the Data Connections enabled.
Q: One of my reports is not working today, but it worked yesterday. All of the other reports still work. How do I fix it?
A: It is possible you modified an area of the prompts page that is causing the prompts to fail? You should not modify any of the fields on the prompt page below row 30.
You can get the original reports back by rerunning the Trial Edition Setup program. This will overwrite all the reports, setting them back to the original version. If you have made changes to reports that you do not want to have overwritten, you should copy the Excel .xlsm files to a location outside the NoetixViews Trial Edition for SLA folder before reinstalling, then copy them back afterwards. Just don’t copy the corrupt file back.
Q: When I open the Excel templates, I get error: [Microsoft][ODBC Driver Manager][/ODBC] Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed
A: This may happen if you are using an Oracle 10.2 client on a Windows 7 machine. The only 10.2 client that is compatible with Windows 7 is 10.2.0.5. If you do not have this version of the Oracle client, you will either need to upgrade your Oracle client or run the Excel reports on a machine that has a compatible combination of Oracle client and Windows operating system.
Q: I sent the Excel reports to a co-worker, but they cannot execute the reports. When they try to login, they get message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
A: Make sure the co-worker has an Oracle client and Excel installed on their machine, that the Oracle client and Excel are both 32- or 64-bit. The Excel reports cannot be run on a machine with a 64-bit Oracle client and a 32-bit Excel, or vice versa. Note that Excel 2007 is always 32 bit.
Also, the ODBC driver name on your co-workers machine must be the same as the ODBC driver name on your machine. In order to obtain the Oracle ODBC driver name, you need to open Windows’ ODBC Data Source Administrator utility but there are two versions. One is 32-bit and the other is 64-bit; the one you use depends on the bit-ness of your Oracle client. The 32-bit ODBC Data Source Administrator utility is located in C:WindowsSysWOW64 and is called odbcad32.exe. The 64-bit ODBC Data Source Administrator utility is located in C:WindowsSystem32 and is also called odbcad32.exe (notice than both names contain “32”).
After opening the utility, click on the Drivers tab and locate the Oracle ODBC driver name in the Name column. The default naming convention is similar to “Oracle in OraClient_home”, where is the version of the client and represents an incrementing number starting with 1 that increments each time you install another Oracle client on the same computer. If the ODBC driver name does not match the one on the machine where the Trial Edition was installed, you will need to talk to your IT department to change the driver name on the second machine.
Q: Why don’t my Excel reports return any data? They worked yesterday.
A: Check the trial days remaining that is displayed on the Prompts page of the Excel workbook. If the trial days remaining is 0, your trial period has ended. See the “What’s Next?” section.
Q: Can I keep the Excel spreadsheets after the Trial ends?
A: Yes, the spreadsheet are left untouched by the uninstall process. They will work with the SLA views in NoetixViews 6.3 General Availability version with a few modifications. Once you are ready to use them with NoetixViews 6.3, contact Noetix Support to learn what changes need to be made.