When you created the DSN using the ODBC Data Source Administrator (make sure you created a System DSN ) which is in the Control Panel under Administrative Tools. Did you get a successful test? If you did, then you could be having issues with the fact that your script is not running with the same credentials as you. Because NTLM is used by default you can do a $dbh=DBI->connect( 'dbi:ODBC:DSN_Name' ) or die $!. Your dba has to set up a seperate account for remote logins. They may give you a hassel about it, but I remember running into a similar problem once and NTLM was the issue. If however, you tested the DSN and it fails, then it is not MSSQL Server, but your network ( make sure the ports are open, a lot of firewall teams block everything now days ). Also, make sure your dba gives you the right group permissions for all the databases you want to access. You can google for tutorials. They abound for using DBI and setting up DSN and DSN-less connections.
JamesNC

In reply to Re: Connect to remote MSSQL database with DBD-ODBC? by JamesNC
in thread Connect to remote MSSQL database with DBD-ODBC? by FinnR

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.