• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 931
  • Last Modified:

Excel : new database query hangs

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.
Thanks
0
akalra
Asked:
akalra
  • 2
1 Solution
 
rrhunt28Commented:
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.
0
 
rrhunt28Commented:
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.
0
 
turn123Commented:
akalra,
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 ! --

Thanks,

turn123
EE Cleanup Volunteer
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now