Re: [otrs] Cannot connect to MS SQL Database

https://www.google.com/search?q=Data+source+name+not+found%2C+and+no+default...) On Wed, Jan 16, 2013 at 11:53 AM, Bevan Agard wrote:

Tried but no luck.

Also this is my DSN string.

$Self->{DatabaseDSN} = "DBI:ODBC:driver={mssql};server=10.5.0.46;database=otrs;uid=otrs;pwd=Password123;"; $Self->{"Database::Type"}='mssql'; $Self->{DatabaseUserTable} = 'users';

Is there something I am missing? Any guidance would be great.

Trust that all thing would work out for the good. Keep standing. Keep believing. Keep hoping. Keep moving forward.

Advertise Your goods and services for free on Trin e-Ads http://www.trin-e-ads.com

On Wed, Jan 16, 2013 at 11:11 AM, Gerald Young wrote:

...

Start here: https://www.google.com/search?q=site:forums.otterhub.org+mssql

On Wed, Jan 16, 2013 at 9:28 AM, Bevan Agard wrote:

...

Guys & Gals

I need some help here. I am trying to setup OTRS ITSM to prove to my boss that it can do as good if not better job than Maximo. The problem is that they want me to set it up utilizing our existing MS SQL 2005 database.

I have OTRS installed on a CentOS 6.3 server. I followed all the instruction I found everywhere and from the command line using isql, it works. I even found a perl script to test if my configuration outside of OTRS is good and that works too. However when I run CheckDB.pl it gives me the following:

[root@tetron otrs]# bin/otrs.CheckDB.pl DBI connect('mssql;uid=otrs;pwd=Password123;','otrs',...) failed: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002) at /opt/otrs/Kernel/System/DB.pm line 256 ERROR: OTRS-otrs.CheckDB.pl-10 Perl: 5.10.1 OS: linux Time: Wed Jan 16 10:17:50 2013

Message: [unixODBC][Driver Manager]Data source name not found, and no default driver specified (SQL-IM002)

Traceback (31291): Module: Kernel::System::DB::new (v1.144.2.2) Line: 227 Module: bin/otrs.CheckDB.pl (v1.4) Line: 52

Trying to connect to database DSN: dbi:ODBC:mssql;uid=otrs;pwd=Password123; DatabaseUser: otrs

No database connect! ===================================================

This is my

#/etc/odbc.ini

[mssql] Driver = FreeTDS Servername =mssql Port = 1433 Database = otrs

#/etc/odbcinst.ini

# Driver from the mssql-connector-odbc package # Setup from the unixODBC package [FreeTDS] Description = ODBC for Microsoft SQL Driver = /usr/lib64/libtdsodbc.so.0 Setup = /usr/lib64/libtdsS.so UsageCount = 1 Threading = 2

#/etc/freetds.conf [mssql] host = otrs-mssql port = 1433 tds version = 7.0 dump file = /var/log/freetds.log

This is really frustrating and I can't seem to figure this out. Does anyone out there have any clues. Any guidance would be appreciated.

Trust that all thing would work out for the good. Keep standing. Keep believing. Keep hoping. Keep moving forward.

Advertise Your goods and services for free on Trin e-Ads http://www.trin-e-ads.com

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs