As luck (if such a thing exists) would have it, this weekend I am writing a quick program to monitor a table in a database (processing queue for one of our products - on SQL7). With that, said program must run on an NT 4.0 box. However, the SysAdmins don't want to install Perl. I have two choices, then -- one) run the program remotely. two) make a freestanding program with the PDK (Perl Development Kit) from ActiveState (using PerlApp or PerlSvc).

I decided to take option two. Now, keep in mind that the program works already... remotely. I just want to take and "compile" the program. So, I put the code into the format required by PerlSvc. I run
PerlSvc -v -r -s QCheck.pl -e QCheck.exe -f
The code "complies" fine. I run QCheck.exe -install and the program installs fine as a NT service. When I start the program from the services menu, I become frustrated. The program starts and fails. After some tracing, I find that the program dies on the DBI->connect (It took me a second to find because I have no idea where the die information is found). So, I read up on PerlSvc and PDK and find that there is little to NO help on the subject. I did narrow it down to the fact that DBI is calling DBD::ODBC at runtime and the module is not included at compile time. To try and fix the problem, I added the -a switch to my build and added the DBD::ODBC .dll... still no luck.

Has anyone had luck using PerlSvc to create a freestanding executable (that uses DBI)?!? I have also heard that using Tk with PerlApp is difficult, also.

Any help is appreciated.
Casey

In reply to PerlSvc Blues... by cmilfo

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.