QA green button grayed out

I'm running QA on my local PC and going through an ODBC
connection, I've been able to connect to SQL servers on
our network and execute TSQL statements.
Suddenly, last week, the green button is grayed out. No
matter what server. Everything else looks ok. All
features in EM seem to work. In QA, I can connect to the
correct DB and that seems ok. I can type in a command.
But, no green execute button!
I'm running SQL 2000 on my PC. I'm attaching to SQL 2000
and SQL 7.0 servers. The local OS is XP.
Any ideas?
Thanks,
DonHi
And does Ctrl+E work?
John
"Don" <ddachner@.hotmail.com> wrote in message
news:00ad01c3cfd7$463e4470$a501280a@.phx.gbl...
> I'm running QA on my local PC and going through an ODBC
> connection, I've been able to connect to SQL servers on
> our network and execute TSQL statements.
> Suddenly, last week, the green button is grayed out. No
> matter what server. Everything else looks ok. All
> features in EM seem to work. In QA, I can connect to the
> correct DB and that seems ok. I can type in a command.
> But, no green execute button!
> I'm running SQL 2000 on my PC. I'm attaching to SQL 2000
> and SQL 7.0 servers. The local OS is XP.
> Any ideas?
> Thanks,
> Don
>

QA goes, EM doesn't (previously posted on microsoft.public.sqlserver.server)

sory for repost but nobody on sqlserver.server helped me to solve this
:-(((((((((
---
AFAIK QA uses ODBC and EM uses OLE DB right?
anyway, I can connect using QA but not using EM.
tried with IP addredd too with no avail
what's wrong?
tia
Zarko
server: active-pasive cluster win2000as sp3, sql2000sp3a
client: win xp pro, sql2000sp3aWhat is the exact error that is generated?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

QA goes, EM doesn't

AFAIK QA uses ODBC and EM uses OLE DB right?
anyway, I can connect using QA but not using EM.
tried with IP addredd too with no avail
what's wrong?
tia
Zarko
server: active-pasive cluster win2000as sp3, sql2000sp3a
client: win xp pro, sql2000sp3aZarko
What error do you get?
"Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com> wrote in
message news:1074513866.763663@.internet.fina.hr...

quote:

---

> AFAIK QA uses ODBC and EM uses OLE DB right?
> anyway, I can connect using QA but not using EM.
> tried with IP addredd too with no avail
> what's wrong?
> tia
> Zarko
> server: active-pasive cluster win2000as sp3, sql2000sp3a
> client: win xp pro, sql2000sp3a
>

---

|||no error, EM just freezes, I tried to wait but after an hour I just have to
kill it. Tried to increase login timeout in EM to 100 sec but nothing again
Uri Dimant wrote:[QUOTE]
> Zarko
> What error do you get?
>
> "Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com> wrote
> in message news:1074513866.763663@.internet.fina.hr...|||Zarko
Have you tried to register the server in EM?
Have look at client network utility for the server.
"Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com> wrote in
message news:1074515788.992858@.internet.fina.hr...

quote:

---

> no error, EM just freezes, I tried to wait but after an hour I just have

---

to

quote:

---

> kill it. Tried to increase login timeout in EM to 100 sec but nothing

---

again

quote:

---

> Uri Dimant wrote:
>
>

---

|||Well, that's the problem, I cannot register it since it freezes while trying
to connect. On the other machine everything works fine, both machine ping
server by name and IP.
Uri Dimant wrote:[QUOTE]
> Zarko
> Have you tried to register the server in EM?
> Have look at client network utility for the server.
>
>
> "Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com> wrote
> in message news:1074515788.992858@.internet.fina.hr...

QA goes, EM doesn't

AFAIK QA uses ODBC and EM uses OLE DB right?
anyway, I can connect using QA but not using EM.
tried with IP addredd too with no avail
what's wrong?
tia
Zarko
server: active-pasive cluster win2000as sp3, sql2000sp3a
client: win xp pro, sql2000sp3aZarko
What error do you get?
"Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com> wrote in
message news:1074513866.763663@.internet.fina.hr...
> AFAIK QA uses ODBC and EM uses OLE DB right?
> anyway, I can connect using QA but not using EM.
> tried with IP addredd too with no avail
> what's wrong?
> tia
> Zarko
> server: active-pasive cluster win2000as sp3, sql2000sp3a
> client: win xp pro, sql2000sp3a
>|||no error, EM just freezes, I tried to wait but after an hour I just have to
kill it. Tried to increase login timeout in EM to 100 sec but nothing again
Uri Dimant wrote:
> Zarko
> What error do you get?
>
> "Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com> wrote
> in message news:1074513866.763663@.internet.fina.hr...
>> AFAIK QA uses ODBC and EM uses OLE DB right?
>> anyway, I can connect using QA but not using EM.
>> tried with IP addredd too with no avail
>> what's wrong?
>> tia
>> Zarko
>> server: active-pasive cluster win2000as sp3, sql2000sp3a
>> client: win xp pro, sql2000sp3a|||Zarko
Have you tried to register the server in EM?
Have look at client network utility for the server.
"Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com> wrote in
message news:1074515788.992858@.internet.fina.hr...
> no error, EM just freezes, I tried to wait but after an hour I just have
to
> kill it. Tried to increase login timeout in EM to 100 sec but nothing
again
> Uri Dimant wrote:
> > Zarko
> > What error do you get?
> >
> >
> > "Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com> wrote
> > in message news:1074513866.763663@.internet.fina.hr...
> >> AFAIK QA uses ODBC and EM uses OLE DB right?
> >>
> >> anyway, I can connect using QA but not using EM.
> >> tried with IP addredd too with no avail
> >> what's wrong?
> >> tia
> >>
> >> Zarko
> >>
> >> server: active-pasive cluster win2000as sp3, sql2000sp3a
> >> client: win xp pro, sql2000sp3a
>
>|||Well, that's the problem, I cannot register it since it freezes while trying
to connect. On the other machine everything works fine, both machine ping
server by name and IP.
Uri Dimant wrote:
> Zarko
> Have you tried to register the server in EM?
> Have look at client network utility for the server.
>
>
> "Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com> wrote
> in message news:1074515788.992858@.internet.fina.hr...
>> no error, EM just freezes, I tried to wait but after an hour I just
>> have to kill it. Tried to increase login timeout in EM to 100 sec
>> but nothing again
>> Uri Dimant wrote:
>> Zarko
>> What error do you get?
>>
>> "Zarko Jovanovic" <mind_less_s_pa_mm_a_g_a_i_n_s_t@.bigfoot.com>
>> wrote in message news:1074513866.763663@.internet.fina.hr...
>> AFAIK QA uses ODBC and EM uses OLE DB right?
>> anyway, I can connect using QA but not using EM.
>> tried with IP addredd too with no avail
>> what's wrong?
>> tia
>> Zarko
>> server: active-pasive cluster win2000as sp3, sql2000sp3a
>> client: win xp pro, sql2000sp3a