Stephen, My DBA already says that the SQL 2000 client will not connect to the SQL 2005 database. The other item you mention is of interest however. I recall at my last company that the SQL 2000 database was upgraded to SQL 2005 with no known issues, but I'm not sure if it was upgraded in place or restored to a 2005 db. Do you know if SQL 2005 will upgrade a restored db? Thanks, Bruce
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Wednesday, June 27, 2007 4:45 AM To: [email protected] Subject: Re: Installing ARS 5.1.2 on SQL 2005 ** Bruce, You probably already know that SQL 2005 is not supported on 5.1.2 ARS... however here is something to try. Install SQL 2000 on the same computer, then try to install ARS 5.1.2 to your SQL 2005 instance. If that fails then install it to your SQL 2000 instance. After you have installed all the ARS software make a SQL database backup of the ARSystem db. Restore the db to SQL 2005. Then update the ar.cfg file to point to the 2005 server. This may trick ARS into running on SQL 2005. HTH Stephen _____ 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. ##################################################################################### _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
