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