Excel : new database query hangs

Posted on 2003-02-19
Medium Priority
Last Modified: 2012-06-21
Objective : To connect to oracle database and create a new database query.

As I go to menu "Data" and choose "Get External data" and then choose "New Database Query" , My excel shows status bar show the message "waiting for data to be returned from microsoft query" and the my excel session hangs.
It was owrking before when I used to get the login box for user, password and database. Its not happening now. Just to let you know this is a brand new new windows 2000 m/c I am working on.
Question by:akalra
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 7983231
You will have to go into the control panel under admin services, then Data source(ODBC).  You will need to make sure there is a instance for your database listed.  You will have to add the Drive (microsoft odbc for oracle). Then configure it by putting in the info from your database.   Then it should work in excel.  I would configure the driver in the system dns tab, that way anyone using your computer can access it.  Good luck.

Accepted Solution

rrhunt28 earned 200 total points
ID: 7983236
Oh, and btw, if you are running this on a large database it can take minutes for the info to return, I run one every morning on a database that has about 8000 fields, and it takes about one to two minutes for it to update.
LVL 11

Expert Comment

ID: 10104622
No comment has been added lately (328 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to rrhunt28 http:#7983231

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --


EE Cleanup Volunteer

Featured Post

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
Viewers will learn how to use the Hootsuite Dashboard.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question