Discipulus has asked for the wisdom of the Perl Monks concerning the following question:
..and this other one that die on the execute whit:use DBI; my $connect_string = "driver={SQL Server};app=ProvolonePiccante;Server +=100.100.100.100;Database=TEST;UID=usrTEST;PWD=pwdTEST"; my $dbh = DBI ->connect ( "DBI:ODBC:host=localhost;$connect_string" )| +|die; my $str="SELECT * FROM usrTEST.test_table"; $sth = $dbh->prepare($str); $sth->execute ;
Any help appreciated 'cause I have a script working and I cannot write another one. I've goggled a lot without solution. I guess the error is not truly the table name but..use DBI; my $connect_string = "driver={SQL Server};app=ProvolonePiccante;Server +=100.100.100.100;Database=TEST;UID=usrTEST;PWD=pwdTEST"; my $dbh = DBI ->connect ( "DBI:ODBC:host=localhost;$connect_string" )| +|die; my $str="INSERT INTO usrTEST.test_table(\'id_oggi\') VALUES (\'111111\ +')"; $sth = $dbh->prepare($str); $sth->execute ;
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: DBI DBI:ODBC msSQL strangeness
by terce (Friar) on Nov 18, 2005 at 13:24 UTC | |
by Discipulus (Canon) on Nov 18, 2005 at 15:02 UTC |