Greetings!!

We are using ActivePerl 5.6.1 (Build 635) & DBI (1.27) Proxy running on
MS Windows to connect 
to SQL Server from Solaris.

Even though the following SQL query succeeds in MS SQL Query Analyzer,
Via DBI Proxy the 
following query returns an error:

        my $sth = $dbh->prepare( "select lkpver.text_string as
version,lkpst.text_string as 
        status from release_target rt, lookup lkpst, lookup lkpver where
rt.product_issue_id 
        = $bfn and lkpst.lookup_category_name =
'm2_release_target_status' and lkpst.code_int 
        = rt.status_lkp and lkpver.lookup_category_name = 'm2_fix_in'
and lkpver.code_int =   
        rt.fix_in_version_lkp");

        $sth->execute($bfn);

The Error Message:

        DBD::Proxy::st execute failed: Server returned error: Failed to
execute method 
        CallMethod: Can't bind unknown placeholder '1' at
E:/netperl/site/lib/DBI/ProxyServer.pm line 313.
        exec: DBI::st=HASH(0x41f870)

Any Pointers, Help to resolve this issue would be very much appreciated.

Thanks,
-Murali

Reply via email to