Mon May 13 21:26:27 2002
M.
Mon May 13 21:29:47 2002
...
M.
Mon May 13 21:30:45 2002
Tue May 14 07:24:38 2002
Tue May 14 07:28:40 2002
Tue May 14 07:29:09 2002
Tue May 14 07:29:33 2002
Tue May 14 10:53:06 2002
now where's my allowance!
Tue May 14 12:00:26 2002
:)
Thanks.
M.
(Edited by Madan at 5:01 am on May 14, 2002)
Tue May 14 13:09:13 2002
SQL Server has no business connecting to remote databases.
Enterprise Manager, Query Analyzer, and DTS, however, might.
Tue May 14 13:29:18 2002
Any ideas why not?
M.
Tue May 14 14:18:37 2002
Um, some details?
Like, what are you trying to do? Register it in EM? Windows or SQL Server authentication? IP or Named Pipes or what?
etc. etc.
Tue May 14 19:37:34 2002
It worked with my SQL 7 EM but my 2k demo won't.
It just hangs.
M.
Tue May 14 23:16:42 2002
Tue May 14 23:21:17 2002
Tue May 14 23:27:37 2002
Touche.
I'll figure it out on my own.
M.
Wed May 15 13:16:00 2002
Of course, it's entirely possible that I don't know what I'm talking about and DrPizza or Paul Hill will come school us both on backwrds compatability, but in the meantime, if I were you I'd stick to what works. :)
Wed May 15 19:20:46 2002
Is it actually hanging or just waiting for a timeout (i.e. what happens if you leave it for a few minutes)?
Wed May 15 20:00:06 2002
I told you I'm using SQL 2k EM to tap into a remote SQL 7 Server, run by an external hosting company, on a shared host machine. That my machine is Win 98b.
I told you that I set up the new SQL group by using the add group and then inserted the address: sql06.innerhost.com
I also told you that I'm using SQL Server authentication, since I have the username and password. And finally, I told you that I attempt to click the database tab within that group, named HSTORE(address: sql06.innerhost.com) and that it gives the processing cursor(multiple overlapping boxes) but does nothing. I.E., it "hangs".
What precisely, were the questions you were referring to?
madan.
Thu May 16 17:19:09 2002
from Madan posted at 9:00 pm on May 15, 2002
I answered the questions you gave me.I told you I'm using SQL 2k EM to tap into a remote SQL 7 Server, run by an external hosting company, on a shared host machine. That my machine is Win 98b.
I told you that I set up the new SQL group by using the add group and then inserted the address: sql06.innerhost.comI also told you that I'm using SQL Server authentication, since I have the username and password. And finally, I told you that I attempt to click the database tab within that group, named HSTORE(address: sql06.innerhost.com) and that it gives the processing cursor(multiple overlapping boxes) but does nothing. I.E., it "hangs".
What precisely, were the questions you were referring to?
The processing cursor is an hourglass.
If you leave it a couple of minutes, is it still giving you the hourglass, or does it come back with an error?
Thu May 16 17:40:14 2002
I never leave it for more than a minute and a half. But it doesn't connect after 1.5 minutes.
is an hourglass
Not on my machine.
M.
Thu May 16 19:46:22 2002
Thu May 16 20:13:21 2002
I'm assuming that since I'm using a domain, that it would be via IP, no?
M.
Thu May 16 21:48:32 2002
Mon May 20 20:43:14 2002
Wed May 22 09:09:28 2002
Teh firewall always causes problems for me.