It seems like a simple question, but after days of searching, I have found no beginner's-level answer online. I have used WebMatrix successfully to do various and elaborate SELECT, INSERT, UPDATE, DELETE queries using VB and data grids.
However, using Visual Studio 2005 is hardly intuitive. No...
That's the fix, Frederico.
I initially had a problem installing both instances of SQL Server with SQL authentication, so I used what worked at the time: windows auth only. After your suggestion, I managed to change them both to SQL-auth, and all is well now with linked-server access.
Thanks...
I'm doing a new topic in a tutorial, linked servers.
I can already access the other server and DBs on my network from Enterprise Manager and as a new connection in Query analyzer. (SQL Server 2000)
All seems to be in place, except when I try to query the linked server(COMQUAT).
SELECT *
FROM...
Old Man
Maybe, someday soon, I can interrogate they guy who fixed it. Will divulge what I find.
Thanks again for your help.
Why "qotyebw" ? After the 6th try for a unique username failed during sign-up, I gave the keyboard a whack, letting it decide.
The original problem was solved mysteriously. The original administrator returned (after an 8-month absence) to deal with this problem, only to say that it had to do with our file server not running XP pro. So, I'm assuming that all the workstations needed to run the same operating system in...
I doubt that any security is in effect. I seem to be able to run free of such apps.
After more tinkering, I have not made any further progress. I'll recommend that the user get a second workstation running NT, to enable internet access. That sounds stupid, but seems to be the only option at this...
I've disabled Autoconfiguration successfully, did IPCONFIG/RELEASE..RESET, and ensured that there's no ICF running. Still no IP address from the DHCP server, just zeros this time.
It's time to read-up on DHCP, I guess.
Well,
I performed the registry fix for the Autoconfiguration-disable, and checked to be sure no firewall was in effect. I get confirmation that this function is disabled, however no IP address is generated.
Windows IP Configuration
Host Name . . . . . . . . . . . . : warren...
Old Man,
Thanks for your attention. I'll be returning to this issue on Monday morning. In the mean time, we'll likely find more info on this subject. I was totally unfamiliar with XP before this week. I'll learn a bit more before I tickle that keyboard again.
Anyway, it's time for a drive out...
All the NT computers in this network now run fine, however the one remaining XP (in DHCP mode as you outlined) will not accept IP from the Linksys. The XP assigns a different number. I have to manually code an IP in the range of the others in order to access the network. No contact with the...
All the NT computers in this network now run fine, however the one remaining XP (in DHCP mode as you outlined) will not accept IP from the Linksys. The XP assigns a different number. I have to manually code an IP in the range of the others in order to access the network. No contact with the...
Thanks Matt,
I had this issue wrapped up in another discussion group with The Old Man. Of course the adventure continues. Check out June 4.. thread581-284745
With the Linksys router running the DHCP, all is well on all NT computers in the network... except for the one running XP. It's...
XP's Autoconfiguration is incompatible with the network's Linksys router's DHCP. Without experimenting with the registry, how else can I defeat or disable Autoconfiguration?
I can go static IP as you mentioned, and that PC has network access again. However, there's no internet access, as you would expect.
At least that's acceptable for now.
Will check out the link... thanks.
I did find a place to enter a default gateway IP without disabling DHCP.
Upon IPCONFIG/renew, I get the message:
"An error occurred while renewing interface with local area connection..
Unable to contact your DHCP server"
It's XP pro.
How do I change default gateway without going for a static IP/no DHCP? I'm confused about that.
I guess I'd have to take the cover off the PC, and eyeball the network card to determine what type it is...?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.