Using OSQL

[rebel4k]

Could someone advise if it is possible to connect to a SQL database using the OSQL command from a PC that does not have SQL installed or does the PC need to have at least the SQL connectivity tools or an ODBC coonection set up.

 

[SQLBill]

The OSQL tool is part of the SQL Server client tools or connectivity tools. I believe you can also download it from Microsoft's website and don't need the install disk.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

If you copy the osql.exe to another machine it should work fine.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com