Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 977
  • Last Modified:

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?
  • 2
1 Solution
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"

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.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now