"INSERT INTO" won't work but no error message is sent back.

Thomas Noetges thomas.noetges at web.de
Fri Sep 6 09:33:52 EDT 2002


Hi out there,

using FreeTDS with DBI, DBD and all this (Perl), I try (and in some cases
succeeded) to connenct to a MS SQL-Server (2000). "SELECT * FROM ..."
works fine.

When I try to insert something in an existing table "INSERT INTO
tblSomeTable (fldID, fld01, ...) VALUE (1, 'Test', ...)" everything's
fine, too. At first sight... When I look at the table, NOTHING was
inserted also I did no get any error-message. When corrupting the "INSERT
INTO ..." command (e.g. "INSRT NTO ...") an error occurs!

Can anyone enlighten me, what might be wrong. Perhaps somethings with
User-Right or something like that? But why does MS SQL-Server not send an
error?

I user Etherreal ("Port-Sniffer") to look what reaches the MS SQL-Server.
An "INSERT INTO ..." is received (I also knew before because of the
corrupting-thing, described above).

For all tips much thanx in advance.

Kind regards

Thomas Nötges



More information about the FreeTDS mailing list