Very good information Simon, thanks a bunch! Do you happen know off the top
of your head the syntax for adding the port number? If not, its on my list
to scour the internet for examples tomorrow morning. Thanks again for the
info!
Casy Cook
Simon Horwith
<shorwith To: CF-Talk
<[EMAIL PROTECTED]>
@figleaf.com> cc:
Subject: RE: Error message running
command file
12/17/02 04:31
PM
Please respond
to cf-talk
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
