Hello people... Anybody has any clues on how to proceed? Thanks, F.
> -----Original Message----- > From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On > Behalf Of Boniforti Flavio > Sent: Wednesday, December 01, 2010 1:43 PM > To: User questions and discussions about OTRS. > Subject: Re: [otrs] Troubles viewing output on Customer > GUI,MSSQL and charset > > Hello again Mike... > > > There's one thing to pay attention here: OTRS can cache the results > > from the database query for a couple of minutes. This means that if > > you search for 'jim', change your config and again search > for 'jim', > > you'll probably see cached results. > > In that case, the configuration change did not affect your results. > > Please remove the cache and/or change TTL to make sure this > does not > > apply to you. > > I don't know where to remove cache or change TTL, but for > sure it's not "caching" what is disturbing: as I'm running > OTRS on a Virtual Machine, and I reboot it when I reboot my > PC, I feel it's no caching involved. > > > > I understand you know a bit about SQL, therefore I'm > bothering a bit > > > further: would it change if I'd use ODBC connection instead > > of Sybase > > > (like I'm doing now)? > > > Would it be worth a try? If yes, I'd need some help because > > I already > > > tried to connect via ODBC but keep getting failures (when > > testing with > > > "isql" command). Instead, tsql command works pretty well! > > > > Sure, that could help. I remember I used DBD::Sybase once for a > > customer database from Linux >> MS SQL Server successfully. > > Could you eventually provide that configuration excerpt? > > > But DBD::ODBC plus an ODBC driver manager should also work. > > If you have issues, you can certainly try that. > > Well, I'm having issues with ODBC connection using FreeTDS, > would it help if I'd be posting my configs here? > > Kind regards, > Flavio Boniforti > > PIRAMIDE INFORMATICA SAGL > Via Ballerini 21 > 6600 Locarno > Switzerland > Phone: +41 91 751 68 81 > Fax: +41 91 751 69 14 > URL: http://www.piramide.ch > E-mail: fla...@piramide.ch > --------------------------------------------------------------------- > 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