johnmc has asked for the wisdom of the Perl Monks concerning the following question:

Tried to find this answer within Perlmonks and in the interwebs with the search "perl trusted connection"
I throw myself on the mercy of this assemblage...

How do I use a trusted connection to an MS SQL server so I don't have to feed username/password ?

I am currently using:
use DBI;
$dbh = DBI->connect('dbi:ODBC:'.$dbsrvr, $dbuser, $dbpass);

[download]
$dbsrvr = server name
$dbuser = SQL username
$dbpass = SQL password

Thanks in advance any and all help (or abuse)...
J

Replies are listed 'Best First'.
Re: Using trusted connection to MS SQL (blanks)
by tye (Sage) on Mar 11, 2008 at 19:57 UTC

    Just leave off the username and password. 

    my $dbh= DBI->connect(
    "dbi:ODBC:Driver=SQL Server;Server=$dbsrvr",
    '',
    '',
    { RaiseError => 1, PrintError => 0, ... },
);

    [download]

    - tye        

[reply]
[d/l]
Trusted connection to MS SQL using ODBC
by Narveson (Chaplain) on Mar 11, 2008 at 20:09 UTC

    Or use a Data Source Name. That's a Windows thing—try Control Panel, Administrative Tools, Data Sources (ODBC). Then 

    $dbh = DBI->connect("dbi:ODBC:$DSN");

    [download]

    The advantage is that you don't have to hardcode the connection details. If the server name should ever change on you, you can change your DSN, instead of hunting down all the references to it in your Perl code.

[reply]
[d/l]
      Thanks everyone for putting up with my incomplete posting and giving their advice. I did leave out that I am working in a Windoze environment and connecting to a MSSQL database.... Anyway, it was as defining an ODBC connection in ControlPanel and using a DBI->connect. So thanks for the mind-reading and feel free to let me know of the deficiencies of any future posts!
[reply]
Re: Using trusted connection to MS SQL
by jfroebe (Parson) on Mar 11, 2008 at 19:13 UTC
[reply]

Back to Seekers of Perl Wisdom