hi johan, thanks a lot for your interesting post. so as i guess, expect the installation of additional modules, everything works perfect over this ODBC connection? well, in this case i will try to implement this solution with freetds and maybe come back to you if i need some help... if you want me to, of course.
regards, patrick. Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Johan Bogema Gesendet: Mittwoch, 19. November 2008 10:18 An: User questions and discussions about OTRS. Betreff: Re: [otrs] OTRS connection over ODBC to MSSQL Hi, I've set up a connection to our MSSQL database using freetds. This should work. The only problem I still have, is that I cannot install any additional modules. I've already sent a mail around, but I didn't get much help except from Michiel. That mail contained the following information about the problem as I experience it: After some communication with Michiel Beijen, I have to come back to the mailing list, cause he might have found the reason that it doesn't work in my case. When I put out a trace on the mssql server during the installation of a package, I have the following entry: declare @p1 int set @p1=15 exec sp_prepare @p1 output,N'@P1 varchar(80),@P2 varchar(80),@P3 varchar(80),@P4 varchar(80),@P5 varchar(80)',N'INSERT INTO package_repository (name, version, vendor, filename, content_size, content_type, content, install_status, create_time, create_by, change_time, change_by) VALUES (@P1, @P2, @P3, @P4, ''213'', ''text/xml'', @P5, ''not installed'', current_timestamp, 1, current_timestamp, 1)',1 select @p1 He thought that the problem might be caused in the following piece of code in Kernel/System/Package.pm: # add new package my $FileName = $Structure{Name}->{Content} . '-' . $Structure{Version}->{Content} . '.xml'; return $Self->{DBObject}->Do( SQL => 'INSERT INTO package_repository (name, version, vendor, filename, ' . ' content_size, content_type, content, install_status, ' . ' create_time, create_by, change_time, change_by)' . ' VALUES (?, ?, ?, ?, \'213\', \'text/xml\', ?, \'not installed\', ' . ' current_timestamp, 1, current_timestamp, 1)', Bind => [ \$Structure{Name}->{Content}, \$Structure{Version}->{Content}, \$Structure{Vendor}->{Content}, \$FileName, \$Param{String}, ], ); } The problem as he told me, is that there are 5 values (the questionmarks) in the insert statement, from which only 4 are filled in the bind statement. In his database, the last value is a blob field with the contents of the module. I however can not check if this is the case in my database since I don't have any modules installed yet. Does anyone know how to solve this further? Johan Bogema Systems Administrator Realworld Systems Tel: +31 345 614 406 Mobile: +31 6 509 50804 http://www.realworld-systems.com [EMAIL PROTECTED] On 19 nov 2008, at 10:13, Anton Gubar'kov wrote: Hello, I would suggest googling for "mssql dbi" I could find http://www.freeTDS.org People say they could make it work with Perl. Anton. 2008/11/19 Patrick Schiess <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> hi, does anyone of you guys have experiences with an ODBC connection from an OTRS system that runs on a linux system to a MSSQL database? maybe you will ask, why the heck i want to connect to a MSSQL database as i have the possibility to you a MySQL database on the linux machine... well, we need a functionality that doesn't exist on MySQL so far i know... thanks for some replies on this post. regards, patrick. _______________________________________________ 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
