Skip to Content.
Sympa Menu

freetds - RE: "INSERT INTO" won't work but no error message is se nt back.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: RE: "INSERT INTO" won't work but no error message is se nt back.
  • Date: 06 Sep 2002 19:15:48 +0200


Il ven, 2002-09-06 alle 15:11, Thompson, Bill D (London) ha scritto:
> Hi Thomas,
>
> Welcome to FreeTDS!
> This is an interesting one, although not I suspect a FreeTDS issue.
> I say this because :
>
> 1) you are undoubtedly connecting OK ( you can do a select...)
> 2) you can see the commands getting to the server (using ethereal)
> 3) you know that FreeTDS will report back a server side error ( you've tried
> that and it works )
> 4) there's nothing different ( in FreeTDS terms ) between issuing a select
> statement and an insert statement. Both are just text commands which go down
> the line to the server.
>
> So. That leaves us with a problem. I can think of two reasons why you might
> not subsequently see the inserted data
>
> 1) prior to issuing the insert , you issued a "begin tran(saction)"
> statement, and you haven't subsequently committed that transaction with a
> "commit tran(saction)". In these circumstances SQL Server will roll back
> your insert.
>
> 2) When you go and verify the data ( using something like query analyzer I
> presume ) , you are connecting to a different database, or your select
> statement is not retrieving the row for some other reason ( for example, a
> subtle difference between the data you think you inserted and the data you
> actually inserted)
>
> I'll try and think of any other reasons that may cause this, but nothing
> else obvious springs to mind.
>
> Hope this helps,
>
> Bill
>
I don't know..
Yesterday I tried some test with DBD::ODBC (doing make test on
DBD::ODBC...) It do not get a row (after issuing a "exec
sp_datatype_info XX), data are returned correctly, there are no blob but
perl do not get this data... strange. Seeing freetds.log you can see all
returned data (correct)...

In this weekend I'll on mountain (over the Alps), so if someone want to
check...

Just
- download DBI
- install DBI
- download DBD::ODBC
- install it
- configure DBD::ODBC test (see instruction printed doing "make")
- with DBD::ODBC installed do "make test" (in DBD::ODBC source
directory)...

freddy77





  • RE: "INSERT INTO" won't work but no error message is se nt back., Frediano Ziglio, 09/06/2002

Archive powered by MHonArc 2.6.24.

Top of Page