Refreshable spreadsheet question

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Mon, 24 Mar 2008 13:04:49 -0600
Message-ID: <E323160E08E560459CD05A883546C3CE0BCE53FC@earthquake.ICAT.COM>


Not completely Oracle related but thought I'd give oracle-l a shot. I can't find anything on Metalink or Google yet.

I have been given a refreshable spreadsheet - and, oh, what a joy, :-) that connects to an Oracle financials database here in the shop.

Windows Env: Excel 2002 running on XP Pro SP2 Oracle Env (though I don't think it's particularly relevant to this question): 9.2.0.8 running on RHEL.

I am trying to determine the *existing* data source the spreadsheet is trying to use and having no luck at all. If I try to refresh the data I get an MS ODBC error saying that the data source name is not found and there is no default driver specified. Fair enough. I believe that since I haven't set up any ODBC connections on my laptop. And when I click OK I get a dialog box that allows me to choose a data source. But is there a way to determine what data source the initial/existing query/connection is using? I'm thinking the long since gone developer of the spreadsheet used a connection s/he had set up on their laptop.

Thanks,
-joe

I hope...that mankind will at length, as they call themselves reasonable creatures, have reason and sense enough to settle their differences without cutting throats; for in my opinion there never was a good war, or a bad peace. -Benjamin Franklin  

Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 24 2008 - 14:04:49 CDT

Original text of this message