[freetds] freebcp issue connecting to mssql

Konrad J Hambrick konrad at jax01.payplus.com
Tue Nov 14 14:44:16 EST 2006


Michel --

1. How did you create the bcp file ?

    On UNIX / Linux then might the line
    ending be "\n" instead of "\r\n" ?

2. I have also had better luck using
    "SYBCHAR" than "SQLCHAR" with freebcp.

3. I don't use the Format Version 8.0.
    I use 7.0 instead:

       1 SYBCHAR 0  10  "\n"  1  col1

HTH.

-- kjh

Michel Cunha wrote:
> Note that In step 4 I wanted to say:
>  run the command (Note that my DB is called mcunha, the table is called allo)
> Michel
> On Tuesday 14 November 2006 13:44, Michel Cunha wrote:
> 
>>Hi can someone help me with freebcp issue
>>
>>Did freebcp work in the past with MSSQL server ?
>> 
>>Here the steps that I did:
>> 
>>1.create the bcp file
>>a
>>b
>>c
>> 
>>2.create the destination table
>>create table allo (col1 varchar(10))
>> 
>>3.create the format file
>>8.0
>>1
>>1 SQLCHAR 0 1 "\r\n" 1 col1 Latin1_General_CI_AS
>> 
>>4. run the command (Note that my DB is called mcunha, the table is called
>>mcunha)
>>freebcp mcunha..allo
>>in /var/lib/datafilemanager/dataping_aggregated/20061104/000233/datafile3
>>-S19x.1xx.xx.xxx:1433 -U xx -P xx -f/tmp/format
>> 
>>(Note that I change the IP in this email for security reasons :)
>>
>>Then I get this error msg:
>>Msg -100, Level 11
>>unrecognized msgno
>> 
>>I look at google, did not find anything that was usefull
>> 
>>Can anyone help me with this issue ??
> 
> 


More information about the FreeTDS mailing list