I have been trying to figure out a way to insert data into a MS SQL database with no luck. I cannot use the DBI module because
1. I wouldn't install correctly because I don't have make and a C-compiler on the device (Tried PurePerl as well)
Hmm, have you consulted the DBI mailing list about your problems? Are you using ActiveState or strawberry Perl? Strawberry Perl comes with a c-compiler and dmake for making things.

What exactly happened when you tried installing DBI::PurePerl? Again the DBI mailing list would appreciate specific details on your architecture, error msgs, etc. 2. I cannot install the unixODBC or EasySoft because I can't cross-compile it and don't have the needed space if I could.

I guess I'm at the point where I need either a new paradigm to my approach or a stern talking to of how to explaining how to accomplish the above.
Well, you could always use delimited text files and import the data. There are also other agile languages. I've used SQL Alchemy and Python successfully with MS-SQL.



The mantra of every experienced web application developer is the same: thou shalt separate business logic from display. Ironically, almost all template engines allow violation of this separation principle, which is the very impetus for HTML template engine development.

-- Terence Parr, "Enforcing Strict Model View Separation in Template Engines"

In reply to Re: Inserting Data to MS SQL server without DBI by metaperl
in thread Inserting Data to MS SQL server without DBI by clickingwires

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.