[freetds] freebcp issue connecting to mssql
Konrad J Hambrick
konrad at jax01.payplus.com
Tue Nov 14 14:44:16 EST 2006
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
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)
> 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
>>2.create the destination table
>>create table allo (col1 varchar(10))
>>3.create the format file
>>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
>>-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
>>I look at google, did not find anything that was usefull
>>Can anyone help me with this issue ??
More information about the FreeTDS