Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

Help with freetds

Login to Discuss or Reply to this Discussion in Our Community

 
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

LEARN ABOUT DEBIAN

python-config

PYTHON-CONFIG(1)					      General Commands Manual						  PYTHON-CONFIG(1)

NAME

       python-config - output build options for python C/C++ extensions or embedding

SYNOPSIS

       python-config  [ --prefix ] [ --exec-prefix ] [ --includes ] [ --libs ] [ --cflags ] [ --ldflags ] [ --extension-suffix ] [ --configdir ] [
       --help ]

DESCRIPTION

       python-config helps compiling and linking programs, which embed the Python interpreter, or extension modules that can be loaded dynamically
       (at run time) into the interpreter.

OPTIONS

       --cflags
	      print the C compiler flags.

       --ldflags
	      print the flags that should be passed to the linker.

       --includes
	      similar to --cflags but only with -I options (path to python header files).

       --libs similar to --ldflags but only with -l options (used libraries).

       --prefix
	      prints the prefix (base directory) under which python can be found.

       --exec-prefix
	      print the prefix used for executable program directories (such as bin, sbin, etc).

       --extension-suffix
	      print suffix used for extension modules (including the _d modified for debug builds).

       --configdir
	      prints the path to the configuration directory under which the Makefile, etc. can be found).

       --help print the usage message.

EXAMPLES

       To build the singe-file c program prog against the python library, use

	      gcc $(python-config --cflags --ldflags) progr.cpp -o progr.cpp

       The same in a makefile:

	      CFLAGS+=$(shell python-config --cflags)
	      LDFLAGS+=$(shell python-config --ldflags)
	      all: progr

       To build a dynamically loadable python module, use

	      gcc $(python-config --cflags --ldflags) -shared -fPIC progr.cpp -o progr.so

SEE ALSO

       python (1)
       http://docs.python.org/extending/extending.html
       /usr/share/doc/python/faq/extending.html

AUTHORS

       This manual page was written by Johann Felix Soden <johfel@gmx.de> for the Debian project (and may be used by others).

								 November 27, 2011						  PYTHON-CONFIG(1)