https://www.google.com/search?q=Data+source+name+not+found%2C+and+no+default+driver+specified+(SQL-IM002)
On Wed, Jan 16, 2013 at 11:53 AM, Bevan Agard <[email protected]> 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 <[email protected]> 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 <[email protected]>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 >
--------------------------------------------------------------------- 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
