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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]Per 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/