Ciao Alexander, many thanks for your help, I "patched" the problem in my installation, should I have to insert a bug report in OTRS bugzilla ?
-----Messaggio originale----- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] conto di Alexander Scholler Inviato: mercoledì 1 febbraio 2006 8.14 A: User questions and discussions about OTRS.org Oggetto: Re: [otrs] R: re: Customer user backend on MSSQL Hi Simone, >> Hi Simone, >> >>> ODBC connection to microsoft SQL Server works, but I got some problem >>> with >>> OTRS: >>> >>> 1. OTRS look for a table named VALID in my user database (I create a >>> table >>> cloning the one present in the OTRS database) >> >> I think OTRS doesn't look for a -table- called VALID but for a -column- >> called VALID. >> This boolean field indicates whether the customer read from the table is >> valid. >> > > I checked SQL istructions with SQL Profiler to track all operation and > OTRS is looking for a table called VALID I have to create it in my SAP > database. Your are right. Now I had a closer look to the DB-scheme at ftp://ftp.otrs.org/pub/otrs/misc/otrs-2.0-database.png The table valid stores the 3 valid-states used in OTRS. But I can't give you more help. Bye, Alex _______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
<<attachment: winmail.dat>>
_______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/