[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