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
isympy(1)																 isympy(1)

NAME
isympy - interactive shell for SymPy SYNOPSIS
isympy [-c | --console] isympy [ {-h | --help} | {-v | --version} ] DESCRIPTION
isympy is a Python shell for SymPy. It is just a normal python shell (ipython shell if you have the ipython package installed) that exe- cutes the following commands so that you don't have to: >>> from __future__ import division >>> from sympy import * >>> x, y, z = symbols("xyz") >>> k, m, n = symbols("kmn", integer=True) So starting isympy is equivalent to starting python (or ipython) and executing the above commands by hand. It is intended for easy and quick experimentation with SymPy. For more complicated programs, it is recommended to write a script and import things explicitly (using the "from sympy import sin, log, Symbol, ..." idiom). OPTIONS
-c shell, --console=shell Use the specified shell (python or ipython) as console backend instead of the default one (ipython if present or python otherwise). Example: isympy -c python FILES
${HOME}/.sympy-history Saves the history of commands when using the python shell as backend. BUGS
The upstreams BTS can be found at <http://code.google.com/p/sympy/issues/list> Please report all bugs that you find in there, this will help improve the overall quality of SymPy. SEE ALSO
ipython(1), python(1) 2007-10-8 isympy(1)