Post reply

Problem in using ''osql'' utility

  • December 7, 2006 at 5:49 am

    #115592

    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

    #676564

    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

    #676568

    Thankx a lot man.....

    It works.....

    Thankx once again.

  • December 8, 2006 at 1:51 am

    #676827

    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