[otrs] R: re: Customer user backend on MSSQL
alexander.scholler at augsburg.de
Wed Feb 1 08:14:22 CET 2006
>> Hi Simone,
>>> ODBC connection to microsoft SQL Server works, but I got some problem
>>> 1. OTRS look for a table named VALID in my user database (I create a
>>> 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
> 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
Your are right. Now I had a closer look to the DB-scheme at
The table valid stores the 3 valid-states used in OTRS.
But I can't give you more help.
More information about the otrs