×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel / MSQuery / VBScript Crashes when connecting to data source

Excel / MSQuery / VBScript Crashes when connecting to data source

Excel / MSQuery / VBScript Crashes when connecting to data source

(OP)
Please help!!!!!
Any advice or suggestions at all gratefully welcomed!

I'm attempting to connect to an oracle database using Excel (New Database Query - have also tried vbscript, vba, msquery) and it crashes when i try to connect to the data source.

I get the Window:

Program Error
MSQRY32.exe has generated errors and will be closed by Windows. You will need to restart the program.
An error log is being generated.

The data source i'm trying to use is using the driver 'Oracle73 ver 2.5' (SQ032_73.dll). This works on all other users computers just not on this one.

As i said previously ANY comments appreciated as i've been struggling with this for some time!
Thanks
sugarflux

RE: Excel / MSQuery / VBScript Crashes when connecting to data source




Hi,

Try to download a more recent version like SQORA32.dll, vers 9.02.00.00

Skip,

glasses
tongue

RE: Excel / MSQuery / VBScript Crashes when connecting to data source

(OP)
Thanks Skip

This may be the end plan but as i mentioned all other users are using this same version of the dll. As i am a developer for a hundred users i need to be using the same version to ensure that the applications i create are compatible...

Any other ideas please? I have checked that odbc.ini is identical to computers that the source works with. I have copied the dll file from another PC and overwritten my own. Happy to try anything!

Thanks
sugarflux

RE: Excel / MSQuery / VBScript Crashes when connecting to data source





Sorry, no other thots.

Skip,

glasses
tongue

RE: Excel / MSQuery / VBScript Crashes when connecting to data source

Enable tracing on the ODBC datasource and see if that gives any clues.

Tom Morrison
www.liant.com

RE: Excel / MSQuery / VBScript Crashes when connecting to data source

sugarflux,
we have users that's had their computers flattened and backed-up again. During the re-install process, either oracle wasn't re-installed or the drivers weren't re-installed, but all the shortcuts from previous image was there. When they try to connect thru odbc it appears that they have the drivers but didn't. They always have to re-intall oracle client to get their drivers, or download the latest drivers.
tav

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close