<div>
<div class="content wysiwyg-content">
The following string works correctly, opening a connection to my current SQL server database: 
---------------------------------------------------------------------------- 
my $dbh = DBI-&gt;connect('dbi:ODBC:DRIVER=SQL Server; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATABASE=DB1; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APP=Microsoft Data Access Components; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Trusted_Connection=No; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SERVER=ABC;',&quot;$DBuser&quot;,&quot;$DBpw&quot;); 
---------------------------------------------------------------------------- 
How can I substitute a variable that contains the db connection string?
</div>
</div>

The following string works correctly, opening a connection to my current SQL server database:
----------------------------------------------------------------------------
my $dbh = DBI->connect('dbi:ODBC:DRIVER=SQL Server;
                                    DATABASE=DB1;
                                    APP=Microsoft Data Access Components;
                                    Trusted_Connection=No;
                                    SERVER=ABC;',"$DBuser","$DBpw");
----------------------------------------------------------------------------
How can I substitute a variable that contains the db connection string?

Perl database connection

Perl is a high-level, general-purpose, interpreted, dynamic programming languages with over 25 years of development. Perl 5 runs on over 100 platforms from portables to mainframes and is suitable for both rapid prototyping and large-scale development projects.  Perl gained widespread popularity as a Common Gateway Interface (CGI) scripting language, in part due to its regular expression and string parsing abilities. In addition to CGI, Perl is used for graphics programming, system administration, network programming, finance, bioinformatics, and other applications.