Enabling OSQL command in SQL 2005
-
I've installed the 2005 client tools only on a Windows Server 2003 box as required by an application. (the app connects to a separate Server 2003 box running SQL 2005) The app needs to have the client tools running on its box but also needs to be able to use the 'osql' command.
I've installed the tools but when I go to a command prompt and type 'osql', I get 'Failed to load resource file osql.rll', even though the file is there. The PATH statement also has the location.
Is the anything that needs to configured after install to get osql to run? We have 2 other boxes running SQL 2k5 and osql runs just fine on those boxes. My box is on SP2 also. Yes, I realize osql is replaced by sqlcmd but the app needs what the app needs.
I'm pulling my hair out here trying to figure this out. Any ideas?
-
with SQL2005 osql and isql have been replaced with SQLCMD.
If you cannot alter the software to use SQLCMD, I guess you'll need an SQL2000 client install (or msde) to get back to isql and osql
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
You probably had the 2000 tools installed on the server at some point or someone copied things over.
I'd either just start copying over osql and then the DLLs that it complains about from a 2000 box or install the 2000 tools. It's possible that you could mess up the 2005 GUI tools with this, so you might have to reinstall them again.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply