HI, i have a query that insert rows based on a select
statement. When I execute it in the query analyzer it
works fine. But, if I try to execute the same query from
the application reports this error:

[SQLSTATE = 37000 [Microsoft][ODBC SQL Server Driver]
Syntax error or access violation]

The query looks like this:

insert into table1
select * from table2

Do you know what could be the reason for the error??

Thanks a lot for your help.