Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 isql command

Author  Topic 

asarak
Starting Member

36 Posts

Posted - 2005-09-16 : 00:49:14
Hello ,
i am trying to run a from command with the following batch file


cd c:\schedules
isql -U loginname -P password -S server ip -i usr.sql -o output.txt
pause

-U i use the system administrator login
-P also administrators password
-S trying and server name or ip
-i input file which is in c:\schedules
-o output file which is also in c:\schedules

and in the output file has the following..
" Cannot open input file - usr.sql
No such file or directory "

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-09-16 : 01:10:39
It can't open the file "usr.sql". Try putting in the pathname. Have you thought about using osql?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -