On 7/28/06, Daniel Berger <Daniel.Berger / qwest.com> wrote:
> Leslie Viljoen wrote:
> > 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
> >
>
> Did you commit after inserting?

You were right! I didn't realise that some databases don't commit automatically!
I'm really grateful for your help.

Les