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.
2. OTRS use a SQL syntax that is not compatible with SQL Server (directive LIMIT), I changed OTRS source to avoid the use of this directive
I don't know whether LIMIT is a sql-standard-syntax or MySQL-specific. But you can use the corresponding MS-SQL-statement especially because your description sound like you have much customers.
3. now I'm able to use my SAP BO user table, but I'm not able to give access to customer users to OTRS web site (customer.pl)
You have to differ between infos about the customers and authentication of the customers - see doc and mail archive for that. Regard $Self->{'Customer::AuthModule'}. E.g. you can use your ADS for authentication.
4. ODBC give many message (but it work):
Solve 1 and 4, perhaps these messages then disappear. You also can post the relevant parts of your OTRS-configuration.
Subroutine driver redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 34, <PRODU CT> line 4. Subroutine CLONE redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 54, <PRODUC T> line 4. Subroutine connect redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 62, <PROD UCT> line 4. Subroutine prepare redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 89, <PROD UCT> line 4. Subroutine column_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 107, <PRODUCT> line 4. Subroutine columns redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 123, <PRO DUCT> line 4. Subroutine table_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 140, < PRODUCT> line 4. Subroutine primary_key_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 164, <PRODUCT> line 4. Subroutine foreign_key_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 178, <PRODUCT> line 4. Subroutine ping redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 194, <PRODUC T> line 4. Subroutine oldping redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 216, <PRO DUCT> line 4. Subroutine get_info redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 257, <PR ODUCT> line 4. Subroutine do redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 270, <PRODUCT> line 4. Subroutine ExecDirect redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 298, < PRODUCT> line 4. Subroutine GetInfo redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 309, <PRO DUCT> line 4. Subroutine GetStatistics redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 318 , <PRODUCT> line 4. Subroutine GetForeignKeys redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 33 0, <PRODUCT> line 4. Subroutine GetPrimaryKeys redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 34 2, <PRODUCT> line 4. Subroutine GetSpecialColumns redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 354, <PRODUCT> line 4. Subroutine GetTypeInfo redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 362, <PRODUCT> line 4. Subroutine type_info_all redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 371 , <PRODUCT> line 4. Subroutine ColAttributes redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 389 , <PRODUCT> line 4. Subroutine cancel redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 397, <PROD UCT> line 4. Subroutine DBD::ODBC::dr::disconnect_all redefined at C:/OTRS/Perl/site/lib/DBD/ ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::dr::discon_all_ redefined at C:/OTRS/Perl/site/lib/DBD/ODB C.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::_login redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::selectall_arrayref redefined at C:/OTRS/Perl/site/lib/ DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::selectrow_array redefined at C:/OTRS/Perl/site/lib/DBD /ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::selectrow_arrayref redefined at C:/OTRS/Perl/site/lib/ DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::commit redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::rollback redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p m line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::disconnect redefined at C:/OTRS/Perl/site/lib/DBD/ODBC .pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::STORE redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l ine 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::FETCH redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l ine 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::DESTROY redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::_prepare redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p m line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::rows redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm li ne 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::bind_param redefined at C:/OTRS/Perl/site/lib/DBD/ODBC .pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::bind_param_inout redefined at C:/OTRS/Perl/site/lib/DB D/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::execute redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::fetchrow_arrayref redefined at C:/OTRS/Perl/site/lib/D BD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::fetch redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l ine 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::fetchrow_array redefined at C:/OTRS/Perl/site/lib/DBD/ ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::fetchrow redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p m line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::fetchall_arrayref redefined at C:/OTRS/Perl/site/lib/D BD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::finish redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::blob_read redefined at C:/OTRS/Perl/site/lib/DBD/ODBC. pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::STORE redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l ine 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::FETCH redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm l ine 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::FETCH_attrib redefined at C:/OTRS/Perl/site/lib/DBD/OD BC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::DESTROY redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::_ColAttributes redefined at C:/OTRS/Perl/site/lib/DBD/ ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::_Cancel redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::_tables redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::_primary_keys redefined at C:/OTRS/Perl/site/lib/DBD/O DBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::st::DescribeCol redefined at C:/OTRS/Perl/site/lib/DBD/ODB C.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::_ExecDirect redefined at C:/OTRS/Perl/site/lib/DBD/ODB C.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::_columns redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p m line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::_GetInfo redefined at C:/OTRS/Perl/site/lib/DBD/ODBC.p m line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::_GetTypeInfo redefined at C:/OTRS/Perl/site/lib/DBD/OD BC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::_GetStatistics redefined at C:/OTRS/Perl/site/lib/DBD/ ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::_GetPrimaryKeys redefined at C:/OTRS/Perl/site/lib/DBD /ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::_GetSpecialColumns redefined at C:/OTRS/Perl/site/lib/ DBD/ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::_GetForeignKeys redefined at C:/OTRS/Perl/site/lib/DBD /ODBC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::db::GetFunctions redefined at C:/OTRS/Perl/site/lib/DBD/OD BC.pm line 27, <PRODUCT> line 4. Subroutine DBD::ODBC::dr::data_sources redefined at C:/OTRS/Perl/site/lib/DBD/OD BC.pm line 27, <PRODUCT> line 4.
Bye, Alex