In Excel, I open a new spreadsheet, set up a new database query, select the
tables, fields, and criteria for my query, return the data to excel. Once I
return the data to Excel, it appears I am unable to edit the query. I've
tested this in multiple spreadsheets and the same error occurs. Does anybody
have an idea what the issue could be. I am querying an Oracle Database and
am running Excel 2003.
What's the exact error message.
If it's only the warning that MS Query cannot display the query, just ignore
the warning and continue. Otherwise, the error message will hopefully give
us a clue to the problem.
***********
Regards,
Ron
XL2002, WinXP-Proquot;Excel GuRuquot; wrote:
gt; In Excel, I open a new spreadsheet, set up a new database query, select the
gt; tables, fields, and criteria for my query, return the data to excel. Once I
gt; return the data to Excel, it appears I am unable to edit the query. I've
gt; tested this in multiple spreadsheets and the same error occurs. Does anybody
gt; have an idea what the issue could be. I am querying an Oracle Database and
gt; am running Excel 2003.
No error message.
When logged into the query, I click on edit query button and nothing
happens. Sometimes the MS Query program appears to start(appears on the
bottom of screen breifly) but goes away quickly. No error message, but
nothing happens either.
quot;Ron Coderrequot; wrote:
gt; What's the exact error message.
gt;
gt; If it's only the warning that MS Query cannot display the query, just ignore
gt; the warning and continue. Otherwise, the error message will hopefully give
gt; us a clue to the problem.
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Excel GuRuquot; wrote:
gt;
gt; gt; In Excel, I open a new spreadsheet, set up a new database query, select the
gt; gt; tables, fields, and criteria for my query, return the data to excel. Once I
gt; gt; return the data to Excel, it appears I am unable to edit the query. I've
gt; gt; tested this in multiple spreadsheets and the same error occurs. Does anybody
gt; gt; have an idea what the issue could be. I am querying an Oracle Database and
gt; gt; am running Excel 2003.
I have generated the most simple queries of small tables with no criteria and
I am having the same issue.
quot;Excel GuRuquot; wrote:
gt; No error message.
gt;
gt; When logged into the query, I click on edit query button and nothing
gt; happens. Sometimes the MS Query program appears to start(appears on the
gt; bottom of screen breifly) but goes away quickly. No error message, but
gt; nothing happens either.
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; What's the exact error message.
gt; gt;
gt; gt; If it's only the warning that MS Query cannot display the query, just ignore
gt; gt; the warning and continue. Otherwise, the error message will hopefully give
gt; gt; us a clue to the problem.
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Excel GuRuquot; wrote:
gt; gt;
gt; gt; gt; In Excel, I open a new spreadsheet, set up a new database query, select the
gt; gt; gt; tables, fields, and criteria for my query, return the data to excel. Once I
gt; gt; gt; return the data to Excel, it appears I am unable to edit the query. I've
gt; gt; gt; tested this in multiple spreadsheets and the same error occurs. Does anybody
gt; gt; gt; have an idea what the issue could be. I am querying an Oracle Database and
gt; gt; gt; am running Excel 2003.
Unfortunately, I have no experience with that problem. I searched the MSKB
and Google to no avail.
You might try these SWAGs:
-Reboot and try again.
or
-Reboot and recreate the query from scratch.
or
-Use an Excel list or Access table as the data source to see if you get the
same error.
or
Any combination of the above.
Hopefully, somebody has run into this before and can give us some insight.,
***********
Regards,
Ron
XL2002, WinXP-Proquot;Excel GuRuquot; wrote:
gt; I have generated the most simple queries of small tables with no criteria and
gt; I am having the same issue.
gt;
gt; quot;Excel GuRuquot; wrote:
gt;
gt; gt; No error message.
gt; gt;
gt; gt; When logged into the query, I click on edit query button and nothing
gt; gt; happens. Sometimes the MS Query program appears to start(appears on the
gt; gt; bottom of screen breifly) but goes away quickly. No error message, but
gt; gt; nothing happens either.
gt; gt;
gt; gt; quot;Ron Coderrequot; wrote:
gt; gt;
gt; gt; gt; What's the exact error message.
gt; gt; gt;
gt; gt; gt; If it's only the warning that MS Query cannot display the query, just ignore
gt; gt; gt; the warning and continue. Otherwise, the error message will hopefully give
gt; gt; gt; us a clue to the problem.
gt; gt; gt;
gt; gt; gt; ***********
gt; gt; gt; Regards,
gt; gt; gt; Ron
gt; gt; gt;
gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Excel GuRuquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; In Excel, I open a new spreadsheet, set up a new database query, select the
gt; gt; gt; gt; tables, fields, and criteria for my query, return the data to excel. Once I
gt; gt; gt; gt; return the data to Excel, it appears I am unable to edit the query. I've
gt; gt; gt; gt; tested this in multiple spreadsheets and the same error occurs. Does anybody
gt; gt; gt; gt; have an idea what the issue could be. I am querying an Oracle Database and
gt; gt; gt; gt; am running Excel 2003.
I was able to create a query that referred to another excel file, return
data, save file, reopen file, refresh query and update query. So it works
when I query from one excel file to another, but not when I query from excel
to Oracle.... Let me know if anyone has any suggestions. This is very
frustrating.
quot;Ron Coderrequot; wrote:
gt; Unfortunately, I have no experience with that problem. I searched the MSKB
gt; and Google to no avail.
gt;
gt; You might try these SWAGs:
gt;
gt; -Reboot and try again.
gt; or
gt; -Reboot and recreate the query from scratch.
gt; or
gt; -Use an Excel list or Access table as the data source to see if you get the
gt; same error.
gt; or
gt; Any combination of the above.
gt;
gt; Hopefully, somebody has run into this before and can give us some insight.,
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Excel GuRuquot; wrote:
gt;
gt; gt; I have generated the most simple queries of small tables with no criteria and
gt; gt; I am having the same issue.
gt; gt;
gt; gt; quot;Excel GuRuquot; wrote:
gt; gt;
gt; gt; gt; No error message.
gt; gt; gt;
gt; gt; gt; When logged into the query, I click on edit query button and nothing
gt; gt; gt; happens. Sometimes the MS Query program appears to start(appears on the
gt; gt; gt; bottom of screen breifly) but goes away quickly. No error message, but
gt; gt; gt; nothing happens either.
gt; gt; gt;
gt; gt; gt; quot;Ron Coderrequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; What's the exact error message.
gt; gt; gt; gt;
gt; gt; gt; gt; If it's only the warning that MS Query cannot display the query, just ignore
gt; gt; gt; gt; the warning and continue. Otherwise, the error message will hopefully give
gt; gt; gt; gt; us a clue to the problem.
gt; gt; gt; gt;
gt; gt; gt; gt; ***********
gt; gt; gt; gt; Regards,
gt; gt; gt; gt; Ron
gt; gt; gt; gt;
gt; gt; gt; gt; XL2002, WinXP-Pro
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Excel GuRuquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; In Excel, I open a new spreadsheet, set up a new database query, select the
gt; gt; gt; gt; gt; tables, fields, and criteria for my query, return the data to excel. Once I
gt; gt; gt; gt; gt; return the data to Excel, it appears I am unable to edit the query. I've
gt; gt; gt; gt; gt; tested this in multiple spreadsheets and the same error occurs. Does anybody
gt; gt; gt; gt; gt; have an idea what the issue could be. I am querying an Oracle Database and
gt; gt; gt; gt; gt; am running Excel 2003.
Tried something different. Had another user create a query and save the
query from Microsoft Excel. I copied the query to my hard drive. I open a
new spreadshet, new database query, select queries tab, browse to find the
query, when I select the query I get the following error message.
quot;Data source name not found and no default driver specified.quot;
Any thoughts?
quot;Excel GuRuquot; wrote:
gt; In Excel, I open a new spreadsheet, set up a new database query, select the
gt; tables, fields, and criteria for my query, return the data to excel. Once I
gt; return the data to Excel, it appears I am unable to edit the query. I've
gt; tested this in multiple spreadsheets and the same error occurs. Does anybody
gt; have an idea what the issue could be. I am querying an Oracle Database and
gt; am running Excel 2003.
I have one question:
TNSNAMES.ORA?
If you don't know what that means, then I think we may have found your
problem.
Let me know.
***********
Regards,
Ron
XL2002, WinXP-Proquot;Excel GuRuquot; wrote:
gt; Tried something different. Had another user create a query and save the
gt; query from Microsoft Excel. I copied the query to my hard drive. I open a
gt; new spreadshet, new database query, select queries tab, browse to find the
gt; query, when I select the query I get the following error message.
gt;
gt; quot;Data source name not found and no default driver specified.quot;
gt;
gt; Any thoughts?
gt;
gt; quot;Excel GuRuquot; wrote:
gt;
gt; gt; In Excel, I open a new spreadsheet, set up a new database query, select the
gt; gt; tables, fields, and criteria for my query, return the data to excel. Once I
gt; gt; return the data to Excel, it appears I am unable to edit the query. I've
gt; gt; tested this in multiple spreadsheets and the same error occurs. Does anybody
gt; gt; have an idea what the issue could be. I am querying an Oracle Database and
gt; gt; am running Excel 2003.
hello Ron,
I have the exact same problem as Excel GuRu and I do not know what
TNSNAMES.ORA means so please enlighten us
quot;Ron Coderrequot; wrote:
gt; I have one question:
gt; TNSNAMES.ORA?
gt;
gt; If you don't know what that means, then I think we may have found your
gt; problem.
gt;
gt; Let me know.
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Excel GuRuquot; wrote:
gt;
gt; gt; Tried something different. Had another user create a query and save the
gt; gt; query from Microsoft Excel. I copied the query to my hard drive. I open a
gt; gt; new spreadshet, new database query, select queries tab, browse to find the
gt; gt; query, when I select the query I get the following error message.
gt; gt;
gt; gt; quot;Data source name not found and no default driver specified.quot;
gt; gt;
gt; gt; Any thoughts?
gt; gt;
gt; gt; quot;Excel GuRuquot; wrote:
gt; gt;
gt; gt; gt; In Excel, I open a new spreadsheet, set up a new database query, select the
gt; gt; gt; tables, fields, and criteria for my query, return the data to excel. Once I
gt; gt; gt; return the data to Excel, it appears I am unable to edit the query. I've
gt; gt; gt; tested this in multiple spreadsheets and the same error occurs. Does anybody
gt; gt; gt; have an idea what the issue could be. I am querying an Oracle Database and
gt; gt; gt; am running Excel 2003.
For a reason I can't quite fathom, a big company like Oracle built a clunky
interface for external applications to query their databases.
The necessary components a
the Oracle instance
the Client software
AND....the TNSNAMES.ORA file
That is a specially formatted text file that the client software and DSN
connections uses to connect to the Oracle database.
This is a typical TNSNAMES.ORA entry:
prod.busyb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCPCOM.world)
(PROTOCOL = TCP)
(HOST = 131.101.62.20)
(PORT = 1521)
)
)
(CONNECT_DATA = (SID = PROD)
)
)
I use VBA and a DSN-less connection to access Oracle, so I'm a bit rusty on
the specifiics...but, when using ODBC you need to make sure the proper
TNSNAMES entry exists in that file. Your DBA can assist.Does that help?
***********
Regards,
Ron
XL2002, WinXP-Proquot;johnthemonnquot; wrote:
gt; hello Ron,
gt;
gt; I have the exact same problem as Excel GuRu and I do not know what
gt; TNSNAMES.ORA means so please enlighten us
gt;
gt;
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt; gt; I have one question:
gt; gt; TNSNAMES.ORA?
gt; gt;
gt; gt; If you don't know what that means, then I think we may have found your
gt; gt; problem.
gt; gt;
gt; gt; Let me know.
gt; gt;
gt; gt; ***********
gt; gt; Regards,
gt; gt; Ron
gt; gt;
gt; gt; XL2002, WinXP-Pro
gt; gt;
gt; gt;
gt; gt; quot;Excel GuRuquot; wrote:
gt; gt;
gt; gt; gt; Tried something different. Had another user create a query and save the
gt; gt; gt; query from Microsoft Excel. I copied the query to my hard drive. I open a
gt; gt; gt; new spreadshet, new database query, select queries tab, browse to find the
gt; gt; gt; query, when I select the query I get the following error message.
gt; gt; gt;
gt; gt; gt; quot;Data source name not found and no default driver specified.quot;
gt; gt; gt;
gt; gt; gt; Any thoughts?
gt; gt; gt;
gt; gt; gt; quot;Excel GuRuquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; In Excel, I open a new spreadsheet, set up a new database query, select the
gt; gt; gt; gt; tables, fields, and criteria for my query, return the data to excel. Once I
gt; gt; gt; gt; return the data to Excel, it appears I am unable to edit the query. I've
gt; gt; gt; gt; tested this in multiple spreadsheets and the same error occurs. Does anybody
gt; gt; gt; gt; have an idea what the issue could be. I am querying an Oracle Database and
gt; gt; gt; gt; am running Excel 2003.
留言列表
