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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
