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���