Home > Archive > Microsoft SQL Server forum > September 2005 > osql doesn't work









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author osql doesn't work
theintrepidfox@hotmail.com

2005-09-02, 8:23 pm


Dear Group

I'd be grateful if you can help me with the following. I'm trying to
connect to an instance of MSDE called BALTD.

The instance has SQL authentication enabled and the service is running.
Somehow it doesn't what it should do according to MSDN.
When I try connectiong with the following (and variations of it) it
just doesn't do anything. Any ideas why?

osql -u sa -s local\MSSQL$BALTD

C:\Documents and Settings\Martin>osql -u sa -s local\MSSQL$BALTD
usage: osql [-U login id] [-P password]
[-S server] [-H hostname] [-E trusted connection]
[-d use database name] [-l login timeout] [-t query timeout]
[-h headers] [-s colseparator] [-w columnwidth]
[-a packetsize] [-e echo input] [-I Enable Quoted
Identifiers]
[-L list servers] [-c cmdend] [-D ODBC DSN name]
[-q "cmdline query"] [-Q "cmdline query" and exit]
[-n remove numbering] [-m errorlevel]
[-r msgs to stderr] [-V severitylevel]
[-i inputfile] [-o outputfile]
[-p print statistics] [-b On error batch abort]
[-X[1] disable commands [and exit with warning]]
[-O use Old ISQL behavior disables the following]
<EOF> batch processing
Auto console width scaling
Wide messages
default errorlevel is -1 vs 1
[-? show syntax summary]

C:\Documents and Settings\Martin>

Thanks very much for your help and efforts!

Martin

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com