Re: ODBC connection failure

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 06/08/04


Date: Tue, 8 Jun 2004 14:03:43 -0400

So, try the others...

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:199f801c44d81$97deaf90$a301280a@phx.gbl...
> The actual server name is what I'm using.
>
> >-----Original Message-----
> >So what name are you using to refer to the local server?
> Have you tried
> >"LOCALHOST", "(LOCAL)", "127.0.0.1", the actual server
> name, the actual IP
> >address?
> >
> >-- 
> >http://www.aspfaq.com/
> >(Reverse address to reply.)
> >
> >
> >
> >
> >"Mike" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:199ec01c44d7f$b2851cf0$a301280a@phx.gbl...
> >> I need the DSN to run Crystal Reports.
> >>
> >> As for KB #328306, I tried everything under the Server-
> >> Related Causes.  The protocols are all ok, port 1433 is
> >> the same on each machine, and tried giving the server a
> >> new alias.
> >>
> >> As for the Client/App-Related Causes, the protocols
> don't
> >> change, no network adaptor issues, not worried about
> MDAC
> >> connections, and Named Pipes don't apply.
> >>
> >> There was nothing applicable under the Network Causes as
> >> everything is run locally.
> >>
> >> >-----Original Message-----
> >> >> I'm trying to connect from the ODBC Control Panel.
> >> >
> >> >Why?  And then what are you going to do with it once
> >> you've connected?
> >> >Typically this is used to create a DSN for some other
> >> application, like an
> >> >ASP page or VB app.  In which case, you are much better
> >> off connecting
> >> >through OLEDB.  I can't tell you how to do that until
> you
> >> provide more
> >> >information.
> >> >
> >> >> Yes, I have through the 328306 article and haven't
> found
> >> >> any resolutions.
> >> >
> >> >Can you tell us what you tried, with regard to each
> >> article listed at that
> >> >link?  I'm guessing you didn't inspect every single
> >> article listed there,
> >> >since it has been less than an hour, and you'd have to
> be
> >> Number 5 from
> >> >Short Circuit to have read all of the content already.
> >> >
> >> >> Would the easiest thing to do be revert back to
> Windows
> >> >> 2000 when this all worked correctly?
> >> >
> >> >No, that's silly.  Windows XP is not to blame; you
> have a
> >> configuration
> >> >issue, that's all.  If you tell us everything you tried
> >> regarding 328306,
> >> >you will leave the remaining potential options.
> >> >
> >> >-- 
> >> >http://www.aspfaq.com/
> >> >(Reverse address to reply.)
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >


Relevant Pages

  • Re: Usage Report show IP addr instead of computer names
    ... The reverse DNS look-up is only query DNS server, ... | the reverse lookups at 4:30, will that cause the Usage Report to identify ...
    (microsoft.public.windows.server.sbs)
  • Re: OPENSSH 3.4p1-3 on AIX 4.3.3
    ... Teh debug output from the server is exactly the same, ... >another port. ... >reverse dns setup properly for that client? ... >debug1: Server will not fork when running in debugging mode. ...
    (SSH)
  • Re: ODBC connection failure
    ... So what name are you using to refer to the local server? ... > connections, ... >>> Would the easiest thing to do be revert back to Windows ... >>(Reverse address to reply.) ...
    (microsoft.public.sqlserver.server)
  • Re: inbound ssh ceased on 4 servers at same time
    ... Are they really denying the connections or rather just timing out? ... private network were taking forever/never authenticating SSH and a few ... It turned out that the reverse lookup started failing ... Whatever server they had that reverse zone pointed ...
    (freebsd-isp)
  • Re: OPENSSH 3.4p1-3 on AIX 4.3.3
    ... Teh debug output from the server is exactly the same, ... >> another port. ... >> reverse dns lookup. ... >> debug1: Attempting authentication for nicolays. ...
    (SSH)