I've also noticed from time to time that you may need to stop and re-start your web service (I am assuming you are using IIS) if you have run the script pointed at the production DSN. IIS sometimes keeps the script running/in memory for a period of time after you last run it, and restarting the WWW service seems to clear that.
Ben.... -- Benjamin D. Wiechel Xerox Connect [EMAIL PROTECTED] http://members.toast.net/strycher/ -----Original Message----- From: Zoltan Ness [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 5:49 PM To: harsha reddy; [EMAIL PROTECTED] Subject: RE: Perl Database Problem 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 =Z؊ߚzrymjjj _______________________________________________ Perl-Win32-Admin mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
