Post reply

Connecting to SQL Server 2005 from CMD window

  • March 31, 2007 at 11:34 am

    #68352

    I am trying to use the bcp.exe program in a CMD window to create a bulk insert format file.  No matter what I do, I cannot get a connection to the database. 

    The server is a named instance.  Not sure if there is special command-line syntax to deal with that.

    Everything is on the same box, so there are no firewall or UNC naming issues.

    The command I am using is:

    "bcp.exe databasename.tblname format nul -c -t , -f c:\formatfile.fmt -T".

    For what it's worth, I have set "Allow Remote Connections" to true and restarted the database engine.

    I get the errors:

    SQLState = 08001, NativeError = 2

    Named Pipes Provider: Could not open a connection to SQL Server [2]

    Login Timeout Expired

    An error has occurred while establishing a connection to the server.

    Any help would be appreciated.

    Thanks,

    Ken Wells.

  • March 31, 2007 at 2:15 pm

    #697978

    I solved all the issues with this post.

    The named instance was key to the issue.  There is a special flag and parameter needed to successfully connect to a named instance via the command window.

    The format 'database.table' for the source object parameter (taken from SQL Server Help) is incorrect.  After trying many different formats for this parameter, I discovered it.  I have not seen the specific problem documented anywhere.

  • April 19, 2007 at 11:46 am

    #701535

    Then why not post your solution for other folks' benefit ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply