Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: bpollard AT micron.com
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] freebcp is free but I can't make it work
  • Date: Wed, 21 Sep 2005 14:27:39 -0600


> ______________________________________________
> 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)
>
>
>




Archive powered by MHonArc 2.6.24.

Top of Page