For years I've had a server registration using sql server auth set up...now it's failing...can't be found not suthed BS...
I can still see mu other boxes in sql mode, and otyhers in mixed, and I can still see my remote boxes in Ireland and Pennysylvania...we're in NJ..
The person next to me does the same thing, had to reboot, but was fine.
I get ice in the winter...
bizzare-o world.
Any ideas?
Never seen anything like it...
I do know that our tech group has been doing some pushes lately...but I checked my settings and they seem fine..but why would I be able to see everything else but this one instance?...are you registering by IP or DNS name? I know that when i've had problems between here and the great state of Maine I had to reregister using the servers IP.|||can you ping its ip? what does a trace do?|||DNS and I can ping it....|||are you able to ping it both by IP and DNS? (if you can't by DNS ya might try and register it by it's IP)...|||Just tried..I can ping by both...I'm gonna go over and bother the other guy who's connecting to see what's different...|||OK, it was suggested that I try an osql connection from dos...
fact is I already tried that...
BUT it is a great point...for some reason the error message are more helpful..it's like QA interferes with the message...
Then I said, what about bcp...and I got a message I never saw before
C:\>bcp northwind.dbo.orders out orders.txt -SNJROS1D15\NJROS1D151DEV -Usa -Ppwd
CTLIB Message: - L6/O8/S5/N3/5/0:ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
Establishing connection failed.
C:\>
I'm going to try bcp from another box from xp_cmdshell|||Have you installed a Sybase client recently?|||I have a Sybase client AND server running and have no prob.
Brett, did your nw guys push something on the client as well? Try odbcping (of course it'll fail, but try with different security switches) Also, did you happen to do anything in terms of aliasing experimentation? Or maybe in Server Network Configuration on the offending server (sounds like it's offending your intelligence, doesn't it?;)|||The few times I have seen BCP fail with a ct_connect error, it was a Sybase bcp attempting to talk to a MS SQL Server. The problem I always have is that Sybase adds itself to the beginning of the PATH environment variable, so you tend to get it first. I have no doubt you can force the two to get along. Probably only take a couple rolls of duct tape. Here is the error I get for trying to connect to no server:
bcp pubs..authors out auth.txt /Sgarbage /T
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).|||Another possiblity would be hav eyou gotten a beta version of Windows XP SP2? Rumour has it that this will come with a built-in firewall that will block port 1433 by default.
http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.asp
I think we will all be having to play around with this, before our desktop groups get the idea into their heads that they need to deploy this service pack overnight.|||Yup, you're right, I forgot about common utility names. And CTLIB is very suspicious in the content of your error...aka CTlib API, which is Sybase's new web.sql API. Are you screwing with Sybase, Brett?|||Yup installed sysbase months agao...
I like the combiniation of errors thing...yes I think our server ops pushed something last week...
Got the Alias thing to work with the ip address...
What bugs me is that my other NJ is ok..probably on an isolated domain, as well as PA and Ireland...but that doesn't explain PROD on the same network...|||Are you screwing with Sybase, Brett?
Hey, I bought her a drink...
sybase, oracle, db2, sql server....all the same...just a different dress...
Was looking at mySQL...now that's a wolfer...kinda like acess...and now that I say that is access an rdbms? It's definetley not client server...how about foxpro DBaseIII...man they're just to many of them...
which platform would you like to choose?
It's this gdamn network crap I hate...
EDIT: Does Mac have an RDBMS? :eek:|||I have had intermittent problems with Enterprise Mangler where the connection would timeout under TCP/IP, but would be fine under Named Pipes. I never found a rhyme or reason to it. See what happens when you change your default net library in the Client Network Utility. Pretty much reduced to groping at, er...grasping at straws here.|||EDIT: Does Mac have an RDBMS? :eek:
As a matter of fact...sort of. There is a product called 4th Dimension that is an Access-like application. I am not certain if there are any Mac servers to start with. There very well could be, though.|||My original protocal order was Pipes then TCP/IP...when I switched (to enable the alias so I could get some work done), and then tried the bcp in dos, I then get the standard not found. not authed bullshit message...|||As a matter of fact...sort of. There is a product called 4th Dimension that is an Access-like application. I am not certain if there are any Mac servers to start with. There very well could be, though.
Yes there are, they are referred to as Linux boxes ;)|||Anyone know where ODBCPING is located?
M$ says it ships with 6.5 and higher...can't find it...|||It's on the CD, you need to copy it from there into your BINN directory. Or, as an alternative, I can put it here, let me know.|||Thanks...all of the stuff is on a lan share..have to look...
That said...are you telling me it's not part of the install? I select everything...and then why isn't it available as a download from M$?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment