in reply to Re: Re: Re: Re: Re: Updating Specific Fields in MS Access
in thread Updating Specific Fields in MS Access

I now have:
#! C:\perl\bin\perl.exe -w use DBI; #use strict; my $DSN='Database'; my $driver; my $servlist; #connect to database my $dbh=DBI->connect("dbi:ODBC:$DSN", "admin", "") || die; my $sqlstatement=("UPDATE Servers SET Servers.nic1_driver_version=? WH +ERE server=?"); my $sth=$dbh->prepare($sqlstatement); #Open file for reading open(INPUT,"file.txt") || die; while (<INPUT>) { chomp; my ($servlist, $driver)=split(/,/); $sth->execute ($driver,$servlist) || die; } close (INPUT); $dbh->disconnect;
but still get:

DBD::ODBC::st execute failed: Microsoft ODBC Microsoft Access Driver Too few parameters. Expected 3. (SQL-07002)(DBD: st_execute/SQLExecute err=-1) at C:\Perl\scripts\test\newer.pl line 21, <INPUT> line 1.
Died at C:\Perl\scripts\test\newer.pl line 21, <INPUT> line 1.

Thanks again,
jw