Perl and MSSQL connection : DBI:ODBC

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?
winman_softAsked:
Who is Participating?
 
winman_softAuthor Commented:
thank u.. It is workin now!!
I had to install DBI package using " ppm install DBI " command and give the correct port number.
0
 
lcohanDatabase AnalystCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.