it seems that you have a problem with the odbc driver , also beadvised that in SQL Server 7 triggers are after only not like Oracle after and before