Re: ISQL query fails after reboot

That's interesting one ...thanks for posting back.

-Sue

On Sun, 16 Apr 2006 14:01:02 -0700, Richard Tracy
<RichardTracy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thank you for your help Sue. We found what the issue was, we found it was
being caused by an application called NCS (Native Command Substitution. It
is installed with lightspeed which was created by imceda software which has
been bought by quest software. We removed this software and it has worked
without an issue. Again thak you very much for your help

"Sue Hoegemeier" wrote:

You really have to look at the exact full error messages and
the error number. You can try googling on those or try
posting with the full information. Connectivity issues are
generally difficult to troubleshoot via newsgroups. If you
want to do that, you need to post a lot of details, full
error messages, configurations, exact steps to reproduce,
etc. Even then, it can be difficult via newsgroups.

-Sue

On Thu, 13 Apr 2006 23:18:02 -0700, Richard Tracy
<RichardTracy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

We have tried using the -a with no success the error we get is a network
error even if we run it on the localhost. We have also uninstalled sql
server and tried it on a plain vanilla sql server with no success. Any ideas
of how to troubleshoot this would be greatly appreciated

Thank you

"Sue Hoegemeier" wrote:

Have you tried using OSQL instead of ISQL?
In terms of why you are having problems, that's hard to say
without knowing what error message you receive when running
the queries that fail. As a guess, it sounds like you could
be running into issues related to ISQL and the packet size.
Try using the -a switch and increase the default packet
size.

-Sue

On Wed, 12 Apr 2006 07:50:02 -0700, Richard Tracy
<RichardTracy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Good morning we are having a wierd issue with our Windows 2003 server and SQL
2000 sp4 server. From the client side we use isql queries. When we reboot
the server the isql queries that are larger then 512 bytes will fail from
both the client or from the sql server itself smaller ones will work. Query
analyzer works perfectly. The strange part is if we run any query in either
query analyzer or using isql then restart the services everything works. We
also have another server which appears to be identical and everything works
with no issues. If anyone can point me in the right direction to
troubleshoot this issue it would be greatly appreciated.

Richard Tracy





.

Relevant Pages

  • Re: ISQL query fails after reboot
    ... Thank you for your help Sue. ... error messages, configurations, exact steps to reproduce, ... server and tried it on a plain vanilla sql server with no success. ... From the client side we use isql queries. ...
    (microsoft.public.sqlserver.connect)
  • Re: ISQL query fails after reboot
    ... error messages, configurations, exact steps to reproduce, ... server and tried it on a plain vanilla sql server with no success. ... From the client side we use isql queries. ...
    (microsoft.public.sqlserver.connect)
  • RE: Backup issues after changing administrator name
    ... - Did you install any software recently, like Windows Server 2003 SP1? ... please uninstall it and wait for SBS 2003 SP1. ... are there any error messages in the Application or System ... This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.windows.server.sbs)
  • Re: OT - newsservers?
    ... I have since found a server that works, ... Speed: 67220 kb Groups: 109673 Posting: Yes ... Username: None Password: None ... Binaries: Yes Location: United States ...
    (sci.geo.geology)
  • RE: OWA - cant send, reply, or show calendar views
    ... Microsoft CSS Online Newsgroup Support ... This posting is provided "AS IS" with no warranties, ... As you mentioned, the OWA work fine on the SBS Server, but it have ... Please try to test it on other client ...
    (microsoft.public.windows.server.sbs)
Loading