You need to specify the port number. SQL Server runs simulaneous installations on different ports.
~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -----Original Message----- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 17:17 To: CF-Talk Subject: WOT: Error message running command file This one really has me stumped. Any help is greatly appreciated. Background: Trying to execute a command file on the database server to upload a .txt data file. The batch file executes a stored procedure which does some error checking and error file exporting. Command Line for import: bcp salman_devl..correctly_assigned_updates_Load in e: \salman_devl\upload\correctlyassignedupdates_USA.txt -k -t , -e e: \salman_devl\batch\Error_CorrectlyAssignedUpdates_USA.doc -c -T -S xx.x.xxx.xx\db xx's is the database servers IP address. The only problem is this server is running an instance of SQL server 6.5 on the xx.x.xxx.xx IP, but is also running an instance of SQL server 2000 on xx.x.xxx.xx\db It almost sounds like the command line isnt seeing the second instance of our SQL server database and is trying to log into the first instance, and of course, the database is not going to exist. How do you get it to point at the second instance ? By the way this command line has worked on another server which is not sharing instances of SQL server. The command file has been properly executing for over a year. Attempt to locate entry in Sysdatabases for database 'salman_devl' by name failed - no entry found under that name. Make sure that name is entered properly. bcp: unknown option k usage: bcp dbtable {in | out} datafile [-m maxerrors] [-f formatfile] [-e errfile] [-F firstrow] [-L lastrow] [-b batchsize] [-n native type] [-c character type] [-q quoted identifier] [-t field terminator] [-r row terminator] [-i inputfile] [-o outfile] [-a packetsize] [-E explicit identity] [-U username] [-P password] [-S server] [-v version] [-T trusted connection] Thanks, CC ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
