What it does is prepares the DB as though it was of the version that you specify. For e.g. if your server is 2005 but you assign a compatibility level of 80 to the ARSystem database, it is as though this ARSystem database were residing in a version 2000 server. So you might be able to get around your connection problems using this method. I had used this stored procedure years ago when the DBA had upgraded an SQL server from version 6.5 to version 7 without checking with us, and my connection to the ARS had failed. I think it was ARS 4.
So instead of rolling back we tried to find out if we can move further and came up with this solution. This stored procedure is basically designed for migrations when you are moving up on your database version but need its compatibility level to be on another level.. you can only move lower than your server version level. For e.g. if you are on 2000 server you cannot move your database compatibility level to 2005.. Please read the help for this SP so you know what you should expect it to change on your database.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Bruce Scott Sent: Wednesday, June 27, 2007 11:11 AM To: [email protected] Subject: Re: Installing ARS 5.1.2 on SQL 2005 ** Joe, Thanks for the info. Do you know if that will bypass the dll check performed by the installer when attempting to install ARS Server? Thanks, Bruce ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, June 27, 2007 8:08 AM To: [email protected] Subject: Re: Installing ARS 5.1.2 on SQL 2005 ** Hi, Its sp_dbcmptlevel. That is what you use to drop or raise the compatibility level of an SQL database.. Look for help on using it and you should find your way through it.. The different compatibility levels are: 60 = SQL Server 6.0 65 = SQL Server 6.5 70 = SQL Server 7.0 80 = SQL Server 2000 90 = SQL Server 2005 So drop it down to 80 to make it work.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Bruce Scott Sent: Wednesday, June 27, 2007 10:19 AM To: [email protected] Subject: Re: Installing ARS 5.1.2 on SQL 2005 ** Rogerio, I've just finished looking at the thread you mentioned. How did you get AR Server to install on SQL 2005? Thanks, Bruce ---------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Wednesday, June 27, 2007 7:03 AM To: [email protected] Subject: RES: Installing ARS 5.1.2 on SQL 2005 ** Bruce, We did this installation in our enviroment using some advices from Joe D ’Souza (thanks Joe). You can search the archives, search for the “Webservice installation” thread, two weeks ago. HTH, Rogerio Bronzoni Aguiar ---------------------------------------------------------------------------- De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Em nome de Bruce Scott Enviada em: quarta-feira, 27 de junho de 2007 10:55 Para: [email protected] Assunto: Re: Installing ARS 5.1.2 on SQL 2005 I agree that ARS 5.1.2 is not supported on SQL 2005. In fact, the whole point of this exercise is to move off of ARS 5.1.2 to something more supported. I'm just looking for options at this point before I get into the crunch that always comes with an upgrade. Thanks, Bruce ---------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Wednesday, June 27, 2007 4:41 AM To: [email protected] Subject: Re: Installing ARS 5.1.2 on SQL 2005 ** Bruce, I hate to point out the obvious but if you look at the compatibility matrix SQL 2005 is not supported until ARS v7.x. Good luck, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ---------------------------------------------------------------------------- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Scott Sent: Tuesday, June 26, 2007 6:39 PM To: [email protected] Subject: Installing ARS 5.1.2 on SQL 2005 I am trying to move my existing ARS system from Oracle 9i to SQL Server 2005 prior to upgrading the version of ARS. However, I can't get the ARS 5.1.2 installer to recognize the SQL 2005 Client dlls. Newer versions of ARS will install correctly, but I would like to take a smaller jump in changes if possible. Has anyone else experienced this? The error message I'm seeing is this: Cannot load database connection DLL. The database software might not be installed. Click OK to return to the Select Database screen. With an earlier install using the Oracle 9i client this error was attributed to having a semi-colon in place of the colon of the path statement. The path statement has been modified to include the following variants: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Progra~1\Micros~4\90\Tools\Binn \VSShell\Common7\IDE\;"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\" Any suggestions would be greatly appreciated. Bruce Scott Application Developer - Remedy SSG, PetSMART, Inc. Office: 623.587.2340 eMail: [EMAIL PROTECTED] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
