Thank you very much for your email.  I haven't set up the System DSN,
would make sense!  We are using Linux Suse server, do you know how to do
this as I'm very new to linux.
 
Thanks,
Rosanna

________________________________

From: [email protected] [mailto:[email protected]] On Behalf Of
Nathan Campbell
Sent: 17 September 2009 15:48
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Changing MySQL to MSSQL



Did you create a System DSN in the ODBC settings on the server running
the OTRS MSSQL SQL instance? It looks like you would have, but just in
case:

 

(Forgive if this is more information that you need - you probably know
all of this - more for posterity and others in the future.)

 

In Administrative Tools > Data Sources (ODBC) create a SYSTEM DSN -
whatever you name the DSN is the value to enter in your config.pm file:-
it does not have to match the actual database name.

 

For instance, my SQL server is named IMUDD, the database itself is named
otrs, but the value I enter in the config.pm file is SQLOTRS because
that is what I named the System DSN on the SQL Server.

Also, try using the value below for $Self->{DatabaseDSN} instead of
DBI:ODBC:otrs - 

 

$Self->{'DatabaseHost'} = 'IMUDD';

    $Self->{'Database'} = 'SQLOTRS';

    $Self->{'DatabaseUser'} = 'mssql-user-name';

    $Self->{'DatabasePw'} = 'super-secret-password';

    $Self->{DatabaseDSN} = "DBI:ODBC:$Self->{Database}";

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

 

Good luck!

 

Nathan Campbell 
Dallas Symphony Orchestra 



From: [email protected] [mailto:[email protected]] On Behalf Of
Marretta, Rosanna
Sent: Thursday, September 17, 2009 9:35 AM
To: [email protected]
Subject: [otrs] Changing MySQL to MSSQL

 

Hi,

 

I am changing MySQL to MSSQL and need some assistance if I may.

 

 

I have created the database and set up a login for OTRS in my MSSQL.  I
have changed the config.pm file as per below:

 

# DatabaseHost

    # (The database host.)

    $Self->{DatabaseHost} = '[IP or name to your Database]';

    # Database

    # (The database name.)

    $Self->{Database} = 'otrs';

    # DatabaseUser

    # (The database user.)

    $Self->{DatabaseUser} = 'otrs';

    # DatabasePw

    # (The password of database user. You also can use
bin/CryptPassword.pl

    # for crypted passwords.)

    $Self->{DatabasePw} = '[password to sql server for user otrs]';

    # DatabaseDSN

       

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



    $Self->{DatabaseDSN} = "DBI:ODBC:otrs";

    

    $Self->{DatabaseUserTable} = 'users';

 

Perl-DBD-ODBC has also been installed.

 

I ran CheckDB.pl and I'm getting the following error, can anybody please
help me.  Do I have to change another file?

 

 

DBI connect('otrs','otrs',....) failed: [unixODBC][Driver Manager]Data
source name not found, and not default driver specified

 

 

 

Can anybody help?

 

Thanks

 

 

 

 

Rosanna 

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Reply via email to