While you did mention that you adjusted the DSN, that is the most likely location of 
the problem.  The DSN should be pointed to the backup database instance.  The name of 
the DSN does not matter, as long as it is unique and the perl script is pointing to 
it.  Here are a few steps:

1.      Check on SQL Server what the backup db name is (and that it is started).
2.      Configure the DSN with that server and dbname.  
3.      Test the data source connection.

 

        -----Original Message----- 
        From: harsha reddy [mailto:[EMAIL PROTECTED] 
        Sent: Tue 3/25/2003 13:18 
        To: [EMAIL PROTECTED] 
        Cc: 
        Subject: Perl Database Problem
        
        Dear All,
                  I am working on a SQL server database that
        uses ASP and PERL to fetch and update data, I have
        made a copy of the Original database and am making
        changes to it, the original database's name is RUCDR
        and the new one is RUCDRTest.
        
        Everything seemed to be working fine until i
        discovered that the perl files that access and update
        the data are actually fetching and storing the data
        from the main database instead of the copy i created,
        whereas the ASP files access data from the new
        database, I have made sure that all the paths that
        earlier pointed to the main database have been changed
        to point to the new one, even the DSN name is
        different.
        
        I would really appreciate it if someone could help me
        out in this matter.
        
        regards
        harsha
        
        

ޮU��}�vh�����x%��Oz�V�}�٢�X��ǫ�-��^r����칻�&ކ�i��b�����+�J֭y�&�f��f��l���

Reply via email to