Skip to Content.
Sympa Menu

freetds - Re: [freetds] freebcp issue connecting to mssql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Konrad J Hambrick <konrad AT jax01.payplus.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freebcp issue connecting to mssql
  • Date: Tue, 14 Nov 2006 14:44:16 -0500

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 ??






Archive powered by MHonArc 2.6.24.

Top of Page