Moosmann, James wrote:
Nope, same results, Here is a simple example:
Is the syntax invalid?
use DBI; my $dbh = DBI->connect('dbi:ODBC:somedb','',''); my $qs = $dbh->quote( "SELECT \"Rows returned: \" ");
Why are you quoting the entire query as a string?
$dbh->do($qs);
Use a valid query:
$dbh->do("SELECT \"valid column\" FROM \"valid table\"") ...print $dbh->errstr;
---RESULT--- DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rows returned: '. (SQL-42S22)
err, at the risk of sounding pedantic or sarcastic, it would appear there is no column named "Rows returned: ", so I'd say yes, the syntax is invalid...
I'm not a Microsoft user (thank the Lord!!!) but even Bill Gates should be able to understand that error :)
Lee.M
