Re: MSSQL: INSERT into table with TRIGGER
[email protected] ("Martin J. Evans")
| Newsgroups | perl.dbi.users |
|---|---|
| Organization | Easysoft Limited |
| Message-ID | <[email protected]> |
On 30/09/10 15:36, Ludwig, Michael wrote: > MSSQL 2005, SSMS 2005 > Perl 5.10, DBI 1.613, DBD::ODBC 1.24 > > I have an INSERT into a table to which a trigger is attached. > > It works alright from SQL Server Management Studio using > SQL Server authentication for user xyz. > > Using the same user from the same local machine but from Perl, > this silently fails. By which I mean that the execute call > returns 1 (1 row inserted), but actually none has been inserted > in the main table, and the triggered actions haven't been > executed either. > > As said, it works without a problem from SSMS. > > Does anyone know if there is anything special about the driver > or the DBI I have to configure in order to get this working? > > Thanks! Did you use the do method or prepare/execute. If the former, try separating it into a prepare/execute. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com