[otrs] R: re: Customer user backend on MSSQL

[Alexander Scholler]

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