hi all, I am using this to login to my MSSQL2K server. 
my $DSN = "driver={SQL Server};Server=$host;database=$table;UID=$uname
+;PWD=$pwd;";
my $dbh=DBI->connect("dbi:ODBC:$DSN") || die "Error: $DBI::errstr";

[download]
This works fine, until i try to connect to a remote SQL server. The remote connection error string says "Microsoft\ODBC SQL Server Driver\SQL Server\Login failed for user '<MyDomain>\<MyUserName>'. (SQL-28000). Which indicates to me, that the $DSN string doesn't really make much difference ($uname and $pwd are not <MyDomain> and <MyUserName>). So i replaced the variable with: 
my $DSN = "driver={SQL Server};Server=$host;database=$table;";

[download]
The results were the same: local login is OK, remote is not. I am running the scripts under my account, which is an ADMIN member on localhost, but is not on the remote machine, which is probbably why it's possible to access the local sql server. Has anyone got any ideas, why the login is not attempted with the varibles supplied in $DSN? I haven't found any other examples, that would use something other than the $DSN string shown here. 10x, Deda.

In reply to login to MSSQL via DBI::ODBC by Deda

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.