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

pydhcplib

pydhcplib(3)							     PYDHCPLIB							      pydhcplib(3)

NAME

       pydhcplib - une librarie dhcp en python

DESCRIPTION

       pydhcplib  is  a  library  written  in  python  to  reading, writing, encode or decode dhcp packets on network.	The man pages of pydhcplib
       describe the various classes defined in pydhcplib and usable in your python programs.

TYPES

PACKET CLASSES

NETWORK CLASSES

EXAMPLES

SEE ALSO

       pydhcp(8),  pydhcplib.hwmac(3),	pydhcplib.ipv4(3),  pydhcplib.strlist(3),  pydhcplib.DhcpPacket(3),  pydhcplib.DhcpBasicPacket(3),  pydhc-
       plib.DhcpNetwork(3), pydhcplib.DhcpClient(3), pydhcplib.DhcpServer(3)

BUGS

       pydhcplib is under development. See http://pydhcplib.tuxfamily.org/ for more information.

AUTHOR

       Mathieu Ignacio (mignacio[AT]april.org)

																      pydhcplib(3)