Hey all,

I'm having this weird problem on my Windows 2003 Server machine..

Whenever I open two connection pages in Query Analyzer, then close one
of them, it locks up and I have to kill the task.

I read a posting somewhere that said this could be due to an MDAC
installation problem, but I've run MDAC Component Checker and all files
are ok, version 2.8. Also, since I'm running Windows 2003 and MDAC 2.8
is the latest, I can't reinstall it.

There has to be some other cause for this. Why would QA lock up every
time I close a page?

-John

Just noticed it also happened with only one page/connection open.
Seems to happen mostly when I've opened a .SQL file then try to close
it.

Forgot to mention I am on SP3a so that shouldn't be the issue either.
Very strange behavior though..

So no one knows why this happens? Am I the only one??

So no one knows why this happens? Am I the only one??

Hi

It seems like it!!

Is the database you are connecting to on the same server?
Have your tried different protocols?
What version of the client tools are you running?
Have you tried running profiler?

John

<jonhyland@hotmail.com> wrote in message
news:1103230464.588942.116370@z14g2000cwz.googlegr oups.com...
> So no one knows why this happens? Am I the only one??
>

It happens against my local server and remote ones.

Ya, I've tried different protocols, same thing. Local connections use
LPC, remote use TCP.

My version of client tools is 8.00.760 (SP3) which is the latest.

Profiler shows an AUDIT LOGOUT when I close a pane / connection in QA,
as expected. QA locks up after this.

In fact, I don't have to do *anything* for it to happen. If I open two
..SQL files and close one of them, QA will lock up and I have to kill
the process.

It gets really anoying because I spend a lot of time in Query Analyzer.
If no ones had this problem before I guess I'll have to wait till I
reimage my machine, not that that will likely do anything...

By the way, on an unrelated topic I can't stand the new format for
Google Groups. It really sucks and I hope the change it back.

It happens against my local server and remote ones.

Ya, I've tried different protocols, same thing. Local connections use
LPC, remote use TCP.

My version of client tools is 8.00.760 (SP3) which is the latest.

Profiler shows an AUDIT LOGOUT when I close a pane / connection in QA,
as expected. QA locks up after this.

In fact, I don't have to do *anything* for it to happen. If I open two
..SQL files and close one of them, QA will lock up and I have to kill
the process.

It gets really anoying because I spend a lot of time in Query Analyzer.
If no ones had this problem before I guess I'll have to wait till I
reimage my machine, not that that will likely do anything...

Hi

Have you checked the event log?
If your log outs are audited then it seems to be a client error.
If this is only QA then it is not likely to be an MDAC issue.
You may want to remove the client tools and re-install them.
You don't state the OS, but you may want to check it for patches. You may
also want to check the disc for errors and making sure that no other
application such as privacy control or virus checker is causing a problem.

John

<jonhyland@hotmail.com> wrote in message
news:1103247904.469382.129850@c13g2000cwb.googlegr oups.com...
> It happens against my local server and remote ones.
>
> Ya, I've tried different protocols, same thing. Local connections use
> LPC, remote use TCP.
>
> My version of client tools is 8.00.760 (SP3) which is the latest.
>
> Profiler shows an AUDIT LOGOUT when I close a pane / connection in QA,
> as expected. QA locks up after this.
>
> In fact, I don't have to do *anything* for it to happen. If I open two
> .SQL files and close one of them, QA will lock up and I have to kill
> the process.
>
> It gets really anoying because I spend a lot of time in Query Analyzer.
> If no ones had this problem before I guess I'll have to wait till I
> reimage my machine, not that that will likely do anything...
>

Try setting it to show the title only if you haven't already done this.
It's still not brilliant, but better than the one I got when they first
changed it.