Hi guys, Great site! I think I'm going to make this one of my regulars. I've had a problem which has been brewing for some time, and I need to make some decision soon. I have a program running as cgi scripts using MySQL as a database. It's designed to run on both Linux and Win32. What I need to keep some windows people happy is it running as ASP using MSSQL. Looking at ActiveState I should be able to use their PerlScript to retain my current code, and have an ASP extention. The real problem I'm having is finding a way using MSSQL rather than MySQL. The code is updated often, so having two separate versions is not very desireable. Ideally I'd like to have all the database calls, etc, the same, just different database connection. Am I dreaming? From what I've read I'm not sure whether I should be using ODBC, sybase, or antoehr method. Every article on MSSQL I've found seems to be different. Is the syntax the same as MySQL? Will I have to redo all the database routines? Your guidance would be very much appreciated.

In reply to CGI MySQL script to ASP(perlscript) MSSQL by cosmicperl

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.