[freetds] freebcp is free but I can't make it work

bpollard at micron.com bpollard at micron.com
Wed Sep 21 16:27:39 EDT 2005


> ______________________________________________ 
> From: 	bpollard  
> Sent:	Tuesday, September 20, 2005 3:07 PM
> To:	
> Cc:	Subject:	freebcp is free but ....
> 
> Has anyone used freebcp on Solaris?  I am migrating a fairly large job
> to MSSQL and I did not want to re-write it in perl, so I took the
> shell code and replaced isql with tsql, then found freebcp to replace
> bcp.  The only problem is that freebcp does not load the data nor
> produce an error file.  Any ideas?
> 
> unix$ cat /var/tmp/test.out
> 1 2
> 3 4
> 5 6
> 7 8
> 9 0
> 
> MSSQL$ create table test (a char(10), b char(10))
> MSSQL$ grant insert on test to public
> 
> /mu/sdk/freetds/0.61.2/bin/freebcp temp_bcp..test in /var/tmp/test.out
> -c -b 2 -UDBA_SA -Ppwdnotlisted -SBOMSSDEVL19 -e /var/tmp/test.err
> 
> 
> Starting copy...
> 
> 0 rows copied.
> 
> unix$ ls -ltr /var/tmp/test.err
> /var/tmp/test.err: No such file or directory
> 
> Brian D. Pollard
> Database Systems Administration Team Lead
> Micron Technology, Inc. Boise, Idaho
> 208-368-5437 (voice)
> 208-368-5000 enter #7073629  (pager)
> 208-363-4114 (fax)
> 
> 
> 



More information about the FreeTDS mailing list