I am getting the following error while connecting to a MS SQL Server 7 using
ODBC connecting thru a PERL application. The sql statement works perfectly
in Query Analyzer. Income_id is a int identity column, net_income is money
and the rest of the columns are integers. Any thoughts on how I can correct
this problem?

170: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near '='.:
update form10_netincome set film_no = 2532290, net_income = 200012,
inc_year = 2000 where income_id = 67;

Thanks, Tim

Tim,

Your code looks perfectly correct. Use Profiler to see what is sent to
server. I'm afraid your script is getting truncated somewhere.

Shervin

"Tim Hinkel" <thinkel@hotmail6009.com> wrote in message
news:iH8mb.17405$Tr4.36215@attbi_s03...
> I am getting the following error while connecting to a MS SQL Server 7
using
> ODBC connecting thru a PERL application. The sql statement works
perfectly
> in Query Analyzer. Income_id is a int identity column, net_income is
money
> and the rest of the columns are integers. Any thoughts on how I can
correct
> this problem?
>
> 170: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect
syntax
> near '='.:
> update form10_netincome set film_no = 2532290, net_income = 200012,
> inc_year = 2000 where income_id = 67;
>
> Thanks, Tim
>
>