Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^2: Multiple records fetches issue using DBD::ODBC in Perl

by maria80e (Novice)
on Apr 20, 2020 at 10:31 UTC ( #11115826=note: print w/replies, xml ) Need Help??


in reply to Re: Multiple records fetches issue using DBD::ODBC in Perl
in thread Multiple records fetches issue using DBD::ODBC in Perl

I have set DBI TRACE=1 and executed the code.

my $result = $sql->execute() or die "Couldn't execute statement: " . $sql->errstr;

after sql->execute it prints the value as -1.

Actually, I am doing perl upgrade, The existing code has used MSSQL::DBLIB,MSSQL::SQLLIB to execute the stored procedures (MS SQL SERVER)which are deprecated in the higher version.For Windows platform i have used DBI,DBD::ODBC module to connect the Database and execute the stored procedure.

Note: Database connection and stored procedure execution was working fine in perl old version(20 yrs old)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11115826]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (4)
As of 2022-05-25 17:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (90 votes). Check out past polls.

    Notices?