Help with freetds

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Help with freetds
# 1  
Old 07-02-2012
Help with freetds

Hi all,

I have an MS-Sql 2008 server. I need to perform a bulk insert of data (over 1 million records every hour) from an Ubuntu box. Doing this in python using pymssql takes about 30 seconds for every 100,000 records.

I've installed the freetds suite on this ubuntu box. While tsql and isql are able to connect and execute queries successfully, only freebcp keeps throwing a "Msg 2410, Level 2" "Cannot bcp with TDSVER < 5.0" error.

The same bcp tool (Microsoft's version) on a Windows XP virtual box on the same Ubuntu box, can insert to the SQL server without any problem the entire 1million records in just 30 seconds.

I've checked and re-checked every configuration for freetds. It's puzzling why tsql and isql work, but freebcp doesn't.

Any help/pointers on getting freebcp to work or how to get such large data inserted quickly is greatly appreciated.
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question
getting-started(7)						  Numm Tutorials						getting-started(7)

NAME
getting started - numm installation and usage SYNOPSIS
numm-run FILE import numm DESCRIPTION
numm is a python library -- the bastard child of Processing.org and MATLAB, if you will -- that fuses python, numpy, and gstreamer together to create a numerical-computing environment for multimedia generation, analysis, and interaction. Installation A Debian package is provided for ease of installation on Debian and derivative operating systems, such as Ubuntu; we recommend you abandon alternative systems and install Debian, but in the interim direct your attention to virtualization software such as VirtualBox. The following command downloads and installs numm: % wget http://numm.org/numm/releases/python-numm_0.1-1_all.deb % sudo dpkg -i python-numm_0.1-1_all.deb Usage At its simplest, numm provides three pairs of invertable functions that connect common media formats with numpy: Images represented as (height, width, color) numpy.uint8 arrays. o image2np(path) -> np o np2image(np, path) Sounds as (frames, channels) numpy.int16s o sound2np(path) -> np o np2sound(np, path) # XXX: must be .wav Videos as (frames, height, width, color) numpy.uint8s o video2np(path) -> np o np2video(np, path) # XXX: must be .mkv For rapid-prototyping of interactive numpy-based audio-visual experiments, the numm package has a real-time mode. The numm package installs a program named numm-run, which launches (and reloads on modification) python scripts that may implement any subset of the follow- ing functions, which are asynchronously called as needed: o video_in(a) # webcam o video_out(a) # mutate a in-place to set video o audio_in(a) # mic o audio_out(a) # mutate a for audio output o mouse_in(type, px, py, button) o keyboard_in(type, key) SEE ALSO
numm-run(1), numm.one-bit-instrument(7), numm.spectral-analysis(7) numm February 2012 getting-started(7)