December 7, 2006 at 5:49 am
HI,
I am using MS SQL Server 2005, where I want to run a SQL script thru 'osql' utility by using the following command from the command prompt:
osql
-S pc0428 -Usa -Psa123 -d [PO] -i D:\CAMS\DLL\Tables\tbl_access_type1.sql
By executing the same I am getting the folloing error message:
[SQL Native Client]Shared Memory Provider: No process is on the other end of
the pipe.
[SQL Native Client]Communication link failure
Can anybody help me in solving this problem.
Thankx in advance.
Tap
December 7, 2006 at 6:25 am
Now It will work....
osql -S pc0428 -U sa -P sa123 -d PO -i D:\CAMS\DLL\Tables\tbl_access_type1.sql
...If information is ok.
December 7, 2006 at 6:33 am
Thankx a lot man.....
It works.....
Thankx once again.
December 8, 2006 at 1:51 am
If you're working with sql server 2005, you might want to consider switching to sqlcmd. It's a little bit nicer then osql, but the syntax remains the same.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply