Re: Cannot execute through ISQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mustaq (mustaqhussain_at_hotmail.com)
Date: 07/06/04 

Date: Mon, 5 Jul 2004 18:42:24 -0700

Vyas,

Here is the command and query..
C:\Documents and Settings\husmu02>isql -S AH_Stage -d
AH_Baseline -U sa -q "select @@version"

Just to let you know the back ground
Client machine is only installed with MS SQL 7.0 Client
network utility with Mdac 2.7 and configured, Server is
SQL Server 2000 SP3, which is in WAN.

I am able to do ODBC connection and run the query but not
through isql, understand isql doesnot make use of ODBC.

Initially I was thinking to be network problem, but may
not be true, I installed MS SQL Query Analyser from 7.0
release, I can execute the query from Query Analyser

Same command and query if I specify to another MS SQL
server 2000 it works fine.

Any reason on this issue.
And can let me know how does isql work, which ports, dlls
or drivers.

Regards,
Mustaq
Regards,
Mustaq

>-----Original Message-----
>Can you show us the query and the way you are trying to
run the query? Are
>you running it interactively or running it from a batch,
by specifying a
>query or input file?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Mustaq" <mustaqhussain@hotmail.com> wrote in message
>news:2667101c4627f$d424b2c0$a401280a@phx.gbl...
>Hi Vyas,
>
>It doesn't prompts me any error message. It just comes
out.
>
>Regards,
>Mustaq
>
>
>>-----Original Message-----
>>What 's the problem? Any error messages?
>>--
>>HTH,
>>Vyas, MVP (SQL Server)
>>http://vyaskn.tripod.com/
>>Is .NET important for a database professional?
>>http://vyaskn.tripod.com/poll.htm
>>
>>
>>"Mustaq" <mustaqhussain@hotmail.com> wrote in message
>>news:2700c01c46271$e512d660$a301280a@phx.gbl...
>>Hi,
>>
>>I cannot execute ISQL query from dos prompt to one
>>specific MS SQL Server 2000 production machine, but works
>>fine with other server any reason
>>
>>Please let me know ASAP
>>
>>Thanks & Regards,
>>Mustaq
>>
>>
>>.
>>
>
>
>.
>

Relevant Pages

  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Indexing Service, Openquery and sp_executesql
    ... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Problem using Access or Query Designer to run queries in SQL Serve
    ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
    (microsoft.public.sqlserver.odbc)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)