> -----Original Message-----
> From: Martin Edenhofer [mailto:martin@edenhofer.de]
> Sent: Wednesday, July 09, 2003 11:12 AM
> To: dev@otrs.org
> Subject: Re: [dev] OTRS with MS SQL Server

Hi Martin,

> > yes, normally '\'
>
> That means you don't need to quote \?

ups, sorry, i meant you have to quote \

> I improved Kernel/System/DB.pm with mssql specs. Use the 1.29 version
> from cvs (http://cvs.otrs.org/cvsweb.cgi/otrs/Kernel/System/DB.pm).
>
> -=> With ODBC is no auto database type detection possible, so you
>     need to set the database type in your Kernel/Config.pm
>
>     $Self->{'Database::Type'} = 'mssql';
>
> And? :)

maybe i should describe, what i have done at first to connect to the SQL Server.

my Config.pm looked like this:

$Self->{Server} = 'SQL Server';
# DatabaseDSN
$Self->{DatabaseDSN} ="DBI:ODBC:driver=$Self->{Server};Server=$Self->{DatabaseHost};database=$Self->{Database};uid=$Self->{DatabaseUser};pwd=$Self->{DatabasePw};";

with this i can connect to the SQL Server, and most things are working as far as i can see.

if i try this:

# DatabaseDSN
$Self->{DatabaseDSN} = "DBI:ODBC:driver=$Self->{Database}";
$Self->{'Database::Type'} = 'mssql';

i get this error:

(sorry, only german error messages ;-)
Fehler: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben. (SQL-IM002)(DBD: db_login/SQLConnect err=-1)

so next i tried was this:

$Self->{Server} = 'SQL Server';
# DatabaseDSN
$Self->{DatabaseDSN} ="DBI:ODBC:driver=$Self->{Server};Server=$Self->{DatabaseHost};database=$Self->{Database};uid=$Self->{DatabaseUser};pwd=$Self->{DatabasePw};";

$Self->{'Database::Type'} = 'mssql';

this worked for me, i can connect now.

an now my last error is gone :-)
but now i have a new one :-/
in the queue view no more tickets can be viewed.

this error message appears in the log:

 Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Zeile 1: Falsche Syntax in der Nähe von 'LIMIT'. (SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Anweisung(en) konnte(n) nicht vorbereitet werden. (SQL-42000)(DBD: st_execute/SQLExecute err=-1), SQL: 'SELECT st.id, st.queue_id FROM  ticket st, queue sq  WHERE  sq.id = st.queue_id  AND  st.ticket_state_id in ( 1, 4, 6, 7, 8 )  AND  st.ticket_lock_id in ( 3, 1 )  AND  st.queue_id in ( 5 )  AND  sq.group_id IN ( 1, 2, 3, 24, 4, 10, 5, 11, 6, 12, 20, 7, 13, 21, 8, 14, 22, 23, 15, 9, 16, 17, 18, 19 )  ORDER BY st.ticket_priority_id DESC, st.create_time_unix ASC  LIMIT 16'

 Traceback (2012):
   Module: Kernel::Modules::AgentQueueView::Run (v1.36) Line: 173
   Module: Apache::ROOT::otrs::index_2epl::handler (v1.58) Line: 608
   Module: (eval) (v2.01) Line: 149
   Module: Apache::Registry::handler (v2.01) Line: 149

maybe i schould switch back to mysql ;-)

Holger