Recent content by jasbo

One last bit of information. She could import the .csv file without any issue. The issue is importing large selection sets without running into the 2^16 rows limitation in Excel2007, which should actually be able to deal with that limitation. -- jrb

By way of further information.... I am able to use QueryReporter 3.1.0 to create a CSV file with the correct number of rows (140,000+ in this case). I do not have Excel2007, so I can only import the first 65,000 or so rows. I have asked my user to test importing this file into Excel2007. If that...

This is not something I can test because I use an older version of Excel. I asked the use that complained and I got this answer. You can tell me whether you need more information. She responded: Well, it does work but Excel 2007 comes up in "compatible mode" which functions under the rules...

One of my QueryReporter users has just upgraded to Excel 2007. Now she can no longer export files from QR to Excel. I gather that the new Excel files have a different extension than the familiar .xls. Is there a known fix for this? Thanks. --jrb

I have an Oracle instance on one Windows machine. To get TNSPING to work from another computer I needed to add TNSLSNR.EXE to my exceptions list on my Windows Firewall. When I try to connect to this instance from my laptop with PLSDev I get ORA-12170 error. If I turn off the firewall I can...

It worked perfectly. Many thanks. -- jasbo

I just loaded an instance of 10g on my laptop. Since then I can not get Query Reporter to work. PL/SQL Developer worked once I pointed it toward the new ORACLE_HOME. I do not see how to do this with query reporter. TNSPING works fine. SQL Plus works. Query Reporter does not. Any thoughts?