Refreshable spreadsheet question
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 24 Mar 2008 13:04:49 -0600
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
