Hi, We'd like to have OTRS Tickets linked to our existing Customer database. All we need is for the Customer info to be taken from a table/view. Since it's in a Microsoft SQL2000 database, we're trying to do this the easy way, by connecting to the sql2k database with FreeTDS and unixODBC. I just can't figure out how to direct the Customer data through ODBC... This is what we've done so far: (all of this in RedHat 7.3, server choice in install) - install mysql (most recent version from redhat updates) - install otrs :) - install GD-1.41 (the most recent version didn't compile) - install GD::Text - install GD::Graph - install freetds-0.61-2 - install freetds-unixodbc-0.61-2 - configure freetds and unixodbc making sure they can talk with sql2k Can you help us put this scenario working? I'm thinking about an ODBC backend (like the LDAP backend), but don't know how to do it. I did find some lines of code about ODBC in Kernel/System/DB.pm, but didn't understand how to use them. Thanks, -- |)avid ------------------------------------------------- KPNQwest Portugal http://www.KPNQwest.pt