Skip to Content.
Sympa Menu

freetds - bcp.c and 4.2 and/or 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Lowden, James K" <LowdenJK AT bernstein.com>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: bcp.c and 4.2 and/or 7.0
  • Date: Mon, 17 Jun 2002 20:14:19 -0400


Hello Bill Thompson,

I'm hoping you can help me choose how to load my 7.0 server.

The freebcp manpage says 4.2 is broken; does that go for the bcp API?

I haven't been able to get any bulk loading working to my 7.0 server.

With TDSVER=4.2, it's acting a lot like the row terminator is misdescribed.
I can send details if need be.

With TDSVER=7.0, it's not processing the column names for the initial
"insert bulk <tablename> (<colnames>...)" query.

My homegrown app is doing the equivalent of:

bcp db..tab in datafile -c -t\\ -n\\\n

because my data look like:

56\I\New SCB Industry/Sector Classification\
57\I\SCB Emerging Market\

Just wondering what you would expect to work, and where you think I should
focus my attention.

Regards,

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page