bcp.c and 4.2 and/or 7.0
Lowden, James K
LowdenJK at bernstein.com
Mon Jun 17 21:14:19 EDT 2002
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
More information about the FreeTDS
mailing list