From: Leslie Viljoen <leslieviljoen@...>
Date: 2006-07-28T23:46:06+09:00
Subject: SQL Server DBI insert silently fails

Hi all

I am having problems when trying to insert records using dbi-0.1.0 on
Windows XP.
I am using the ADO driver to connect to SQL Server, like so:

connectString = "DBI:ADO:provider=SQLOLEDB.1;Data Source=10.0.0.1;User
id=xxxx; password=xxxx;Initial Catalog=DevDB"

I get rows == nil when I run this:

qry = "insert into G2.dbo.Device (IPadress, SerialNumber, VehicleID, " +
            "SerialNumberB, Tag1, Tag2, FwVersion, HwVersion) values
(?, ?, ?, ?, ?, ?, ?, ?)"
rows = @database.do(qry, device[:ip], device[:serial],
device[:serial], device[:serial], 0, 0, 0, 0)
print "rows done: "
p rows


..and the record is not inserted. I get no other error response.


The strange thing is that select queries function perfectly, giving me
valid data back.
Any ideas?


Les