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