Your skill will accomplish what the force of many cannot |
|
PerlMonks |
pass MS SQL server scripts into Win32::ODBCby Anonymous Monk |
on Jan 23, 2013 at 22:07 UTC ( [id://1015037]=perlquestion: print w/replies, xml ) | Need Help?? |
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question: Hello monks and mongers! while using Win32::ODBC to query a MS SQL server database, simple select statements work very well with $connection->Sql. I have a need of executing lengthy prebuilt SQL query files or scripts. I can easily do this by shelling out to the command line to execute an osql or sqlcmd and run the script, capture the results in an array or hash But... I would prefer to use Win32::ODBC and keep it all in Perl if I can All attempts I have made, that work with simple select statements error, when I substitue the select statements with the script file name or a variable which contains the name of the file. Any guidance will be appreciated
Back to
Seekers of Perl Wisdom
|
|