in reply to Re^6: speedup sqlserver insert
in thread speedup sqlserver insert

So what you showed previously was not actual code but your interpretation of the documentation?

If you get errors, please tell us that you get errors and also show us these errors instead of making us guess.

As the next step forward, please use the example I took from the documentation and adapt it to your program.

Replies are listed 'Best First'.
Re^8: speedup sqlserver insert
by Anonymous Monk on Sep 12, 2014 at 14:31 UTC
    it was my code. what I ended up with (and thanks)
    my $dsn = "dbi:ODBC:Driver={SQL Server};Server=xxxx\\yyyy"; $dbh = DBI->connect($dsn, $user, $password,{ RaiseError => 1, AutoComm +it => 0 }) or die;