>>i've set a db, built a tsql stmt for sql server to insert records into a table.
>>db.execute SQLStmt, dbSQLPassThrough
>>
>>statement fails. what am i missing?
>
>more info
>sqlstmt works when run directly in sql server enterprise manager
>sqlstmt is 'insert into appl_t (col1, col2, ...) values(val1, val2, ...)


got it to work using querydef instead of direct from database object. will still accept ideas for direct from db object...