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. It 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.

  I haven't consulted the DBI mailing list, but I will be now. I not sure which type of Perl I am using because I did not build it. The company for the device built it. If I had to guess, ActiveState.

What exactly happened when you tried installing DBI::PurePerl? Again the DBI mailing list would appreciate specific details on your architecture, error msgs, etc.

    The way I went about installing PurePerl was copy and paste. I tried to use the CPAN module to install it but it kept on hanging and quitting. The error that I got from perl in regards to the MySQL, for testing without installing unixODBC or EasySoft, was that it might not have been installed properly. Possibly because I took the copy paste method?

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

     I am trying to stay away from having the "Remote" server do anything because we have a server that is local to my building and full permissions. But there is a second server several hundred miles away and only have limited rights to access.

    Also, I am trying to make this device as simple and easy to set up. The end goal is to have a technician level employee, with very limited command line skills, be able to execute a install script to completely install the device. I have been sticking to what comes factory installed on the device. The available memory on the system isn't very much and all my program, and libraries, are located on a compact flash card.

In reply to Re^2: Inserting Data to MS SQL server without DBI by clickingwires
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.