Customer user backend on MSSQL
Ciao OTRS database is on mySQL, customers Users database in a Microsoft SQL Server database (managed by SAP Business One). OTRS is running onto a windows 2000 server, so I think that I cannot use FreeDTS. Do you know where may I find a MSSQL/SYBASE perl module usable on windows2000 ? I tried to find it, but only source are available. Because I'm not able to connect to MS-SQL, I'm writing a small program to copy Users data into the OTRS mySQL database table, but of course a direct connection to a DB view will be the correct solution. thank you for your help. Cordiali saluti. Simone Girlanda
Hi Simone,
OTRS database is on mySQL, customers Users database in a Microsoft SQL Server database (managed by SAP Business One).
OTRS is running onto a windows 2000 server, so I think that I cannot use FreeDTS.
... could be used, if you build it. But this shouldn't be necessary.
Do you know where may I find a MSSQL/SYBASE perl module usable on windows2000 ? I tried to find it, but only source are available.
As mentioned above, FreeTDS should be a right choice. But in your case (under Win), you should use DBI::odbc in connection with the MS-SQL-ODBC-connectivity without problems (but I don't have experience on that). $Self->{CustomerUser} = { Name => 'Database Backend', Module => 'Kernel::System::CustomerUser::DB', Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:odbc:yourdsn',
Simone Girlanda
Bye, Alex
participants (2)
-
Alexander Scholler -
Simone Girlanda