[Tue Jun 23 18:03:55 2009] [error] [client 10.4.3.5] DBD::ODBC::db prepare failed: [FreeTDS][SQL Server]Statement(s) could not be prepared. (SQL-42000), referer: http://support.hidden.com/cgi-bin/transpose-qqs.cgi
[Tue Jun 23 18:03:55 2009] [error] [client 10.4.3.5] [FreeTDS][SQL Server]Could not find server 'DC?' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. (SQL-42000) at /var/www/cgi-bin/transpose-qqs.cgi line 329., referer: http://support.hidden.com/cgi-bin/transpose-qqs.cgi
[Tue Jun 23 18:03:55 2009] [error] [client 10.4.3.5] Can't call method "execute" on an undefined value at /var/www/cgi-bin/transpose-qqs.cgi line 338., referer: http://support.hidden.com/cgi-bin/transpose-qqs.cgi
##</code><code>##

my $db11 = "DC:server1";
my $dbor = "DC:server2";

    FROM openquery([$db11], N\'
        SELECT
            r.ReqID
            , de.varc_EmploymentPriority
            , d.candidateid
            , d.FirstName + \'\' \'\' + d.LastName
            , r.sHiringManager
            , d.DossierType

    \') as hc join openquery([$dbor], N\'
        SELECT
            p.first_name
            , p.last_name
            , c.id
            , replace(replace(dbms_lob.substr(a.answer,4000,1),chr(10), \'\' \'\'),chr(13), \'\' \'\') as "Answer"
            , replace(replace(dbms_lob.substr(ql.question,4000,1),chr(10), \'\' \'\'),chr(13), \'\' \'\') as "Question"
            , CASE ql.type