<div>
I think you don't have a ODDBC driver and data source installed/configured for OTRS to work with SQL Server and please see more details at link below &quot;Install OTRS using SQL Server 2008&quot;<br />
<br />
<a href="http://forums.otrs.org/viewtopic.php?f=62&t=9405" rel="ugc">http://forums.otrs.org/viewtopic.php?f=62&t=9405</a><br />

</div>


I think you don't have a ODDBC driver and data source installed/configured for OTRS to work with SQL Server and please see more details at link below "Install OTRS using SQL Server 2008"

http://forums.otrs.org/viewtopic.php?f=62&t=9405 [http://forums.otrs.org/viewtopic.php?f=62&t=9405]


<div>
<a href="http://wiki.otrs.org/index.php?title=Installation_on_Win2003_with_Microsoft_SQL_Server" rel="ugc">http://wiki.otrs.org/index.php?title=Installation_on_Win2003_with_Microsoft_SQL_Server</a>
</div>


http://wiki.otrs.org/index.php?title=Installation_on_Win2003_with_Microsoft_SQL_Server [http://wiki.otrs.org/index.php?title=Installation_on_Win2003_with_Microsoft_SQL_Server]

<div>
<div class="content wysiwyg-content">
I am using OTRS ticketing services , currently it is run on mysql database .<br />
I am trying to shift it to MSSQL database , all the configuration is done but when I load the main page (index.pl) I get the following error : <b>[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied.</b><br />
<br />
The connection string used is : $Self-&gt;{'DatabaseDSN'} = &quot;DBI:ODBC:driver={SQL Server};Server=$Self-&gt;{Dat<wbr />abaseHost}<wbr />,1433;data<wbr />base=$Self<wbr />-&gt;{Databas<wbr />e}&quot;;<br />
$Self-&gt;{'Database::Type'} = 'mssql';<br />
<br />
Is it somethin to do with DBI:ODBC driver ? how do i install it?
</div>
</div>


I am using OTRS ticketing services , currently it is run on mysql database .
I am trying to shift it to MSSQL database , all the configuration is done but when I load the main page (index.pl) I get the following error : [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied.

The connection string used is : $Self->{'DatabaseDSN'} = "DBI:ODBC:driver={SQL Server};Server=$Self->{DatabaseHost},1433;database=$Self->{Database}";
$Self->{'Database::Type'} = 'mssql';

Is it somethin to do with DBI:ODBC driver ? how do i install it?

Perl and MSSQL connection : DBI:ODBC

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.

Perl

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.