|
|
Choosing A Webhost: |
Freebcp and column names with spaces: msg#00101db.tds.freetds
FreeTDS people, FreeTDS has been working very well for me. I am talking to a MS SQLServer (version 2003, I think) with the Python drivers, and it works well. However, now I am trying to use freebcp to improve the throughput to build a big table (SQL INSERT statements are just too slow). I started testing it and immediately found a problem. Many of my column names contain embedded spaces (please do tell me not to do that; there is a reason). The internals of freebcp do not quote the column names. The routine _bcp_build_bulk_insert_stmt in dblib/bcp.c simply copies in the column name without examining it. I did try turning the TDS version down to 4.2, and the freebcp run succeeded, but then my normal code does not run, plus it appears that some of the fields were mangled during the insert. Is this a bug? Can you just add quotes around the column name? Or, am I missing something? Thanks very much for the help. Paul Rensing paulrensing@xxxxxxxxxxx -- Paul Rensing <paulrensing@xxxxxxxxxxx>
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: TDS_ROWFMT_RESULT vice TDS_CMD_FAIL correction..., Frediano Ziglio |
|---|---|
| Next by Date: | Re: Freebcp and column names with spaces, Paul Rensing |
| Previous by Thread: | Re: TDS_ROWFMT_RESULT vice TDS_CMD_FAIL correction..., Ian Harding |
| Next by Thread: | Re: Freebcp and column names with spaces, Paul Rensing |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |