How to config MS SQL customer backend

[woopsboy]

I've never use perl application before. I managed to install OTRS on Windows 2008 Server x64 on MS SQL standard. My ERP is running on MS SQL, I am trying to find a MS SQL sample config.pm. After three days, I could not find any. Can anyone provide a sample code for connecting to a MS SQL customer backend and authentication. (I never seen a line of perl code before)

[Mothra]

I've never use perl application before. I managed to install OTRS on Windows 2008 Server x64 on MS SQL standard. My ERP is running on MS SQL, I am trying to find a MS SQL sample config.pm. After three days, I could not find any. Can anyone provide a sample code for connecting to a MS SQL customer backend and authentication. (I never seen a line of perl code before)

A quick Google on "otrs mssql" turned up this as the first link: http://faq.otrs.org/otrs/public.pl?Acti ... ItemID=121

Any help?

[woopsboy]

I used this one for setting up OTRS running on MS SQL, and have to change the table from "system_user2" to "users" to get it work. However, it is different from setting up MS SQL customer backend.

I do not know Perl Syntax, whould really love to have sample for the customer backend. I know MS SQL well, but not Perl, may be I nedd to read up Perl basic.

[crythias]

http://doc.otrs.org/3.0/en/html/x2276.html Tells you how to use a separate customer backend

"But it's not MSSQL!"

You need a connection string for that.

Code: Select all

    Params => {
        # if you want to use an external database, add the required settings
#        DSN => 'DBI:odbc:yourdsn',
#        DSN => 'DBI:mysql:database=customerdb;host=customerdbhost',
#        User => '',
#        Password => '',
        Table => 'customer_user',
    },

a # is a comment, which means that if you see it, the line is ignored.

You should let us know what version of OTRS and what OS you're running ...

You may need FreeTDS in Linux or simply an ODBC link/DSN in Windows.