[EMAIL PROTECTED] wrote:
When I try to run a perl script that uses ODBC drivers to insert data
more than 70000 rows I am getting the following error....
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL
Server]Procedure has no parameters and arguments were supplied.
(SQL-42000)(DBD: st_execute/SQLExecute err=-1) [for Statement "INSERT
INTO
db.guest.portfolio_event_1_310_3560_3(col1,col2,col3,col4,col4,col5)
VALUES (?,?,?,?,?)" with ParamValues: 4=' ', 1='1754079', 2=' ',
3='0', 5=' '] at /usr/local/lib/perl5/site_perl/5.8.6/DBIx/
ContextualFetch.pm line 51
Could someone help me in this aspect......
Thanks,
Neel
It is a SQL Server error reported by the FreeTDS ODBC Driver. I would
not rule out DBD::ODBC but:
"Procedure has"
looks like something (FreeTDS perhaps) was attempting to call a
procedure but for some reason the name is not known (look at the two
spaces between "Procedure" and "has". I don't use FreeTDS myself but I
do know that for "insert into...." DBD::ODBC is not going to call any
procedures itself.
Has your table perhaps got triggers associated with it?
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
