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] ---------------------------------------------------------------------------- -- The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. ---------------------------------------------------------------------------- -- __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ---------------------------------------------------------------------------- -- The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. ---------------------------------------------------------------------------- -- __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ---------------------------------------------------------------------------- -- The information contained in this electronic mail message, including attachments, if any, is PetSmart confidential information. It is intended only for the use of the person(s) named above. If the reader of this message is not the intended recipient, or has received this message in error, you are hereby notified that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you are not the intended recipient or have received this message in error, please notify the sender via e-mail and promptly delete the original message. ---------------------------------------------------------------------------- -- __20060125_______________________This posting was submitted with HTML in it___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007 11:54 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
