[freetds] freebcp fails silently

Jonathan Gordon freetds.org at kinobe.com
Thu Nov 1 13:54:22 EST 2007


I'm a new user and attempting to use freebcp. I've successfully used tsql to make queries to databases on MSSQL 2000 and 2005. I have successfully used bcp from Windows machines to bulk copy to both of these servers. I've gotten to the point where I run the freebcp command and it will fail with instructive errors if I input the wrong table name, login info, or server info. However, when all of that is correct and I run freebcp I don't receive any errors but no data gets uploaded. Can anyone help me figure out what's going wrong? Ideally, my target server is MSSQL 2005, so answers for that are most appreciated. 

*** Begin Environment Description ***
SQL Server 2000: 8.00.2039	SP4	Enterprise Edition
and
SQL Server 2005: 9.00.3050.00	SP2	Standard Edition

FreeTDS version: FreeTDS 0.64
Which client library you are using: freebcp
Client OS and hardware architecture: Linux kubuntu 2.6.20-16-386 #2 Sun Sep 23 19:47:10 UTC 2007 i686 GNU/Linux
*** End Environment Description ***

I receive the same lack of response when I set the environment variable TDSVER=7.0 or TDSVER=8.0. Using any other TDSVER yields:

*** Begin error message ***
Msg -100, Level 11
unrecognized msgno
*** End error message ***

Here's the command I'm running:
freebcp "mailing_analysis..MATCH_MAILING_CAMPAIGN" in "/usr/local/work/kinobe/head/matching/application/application-assets/anchor/input/20071031.txt.out"  -Usa -Pxxxxxx -S192.168.15.100:1433  -f "/usr/local/work/kinobe/head/matching/application/application-assets/anchor/input/bcp.format"  -m 1 -F 1

I've attached the format file and the data file (1 line) as well as the error log I obtained via  export TDSDUMP=/tmp/freetds.log

Please let me know what I can do to figure out what's going wrong.

Thanks,

Jonathan.


-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: bcp.format
Url: http://lists.ibiblio.org/pipermail/freetds/attachments/20071101/1c76221a/attachment-0002.bat 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: freetds.log
Type: text/x-log
Size: 17868 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20071101/1c76221a/attachment-0001.bin 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 20071031.txt.out
Url: http://lists.ibiblio.org/pipermail/freetds/attachments/20071101/1c76221a/attachment-0003.bat 


More information about the FreeTDS mailing list