At 02:12 PM 1/10/2003 -0500, you wrote:
I have found that I have to SDETACH before I do the SATTACH in order to get rid of that darned connection box. I've been told I shouldn't have to do that, but I kept getting those boxes popping up. Putting a SDETACH first made them go away!
Karen,
When the database is DISConnected, the SCONected database is also DISConnected. But, the SATTACHed tables are still attached. So, if you try to access the data from any SATTACHed table(s), it is looking for the actual database source and if the data source database is not connected, it has to display that pop up dialog box. In order to avoid that dialog box, you'll need to ONLY use SCONNect DSNName IDENTIFIED BY UserID Password command right after you connect the database, every time. You can automate that task either in your startup DAT file or use ON CONNECT RUN CommandFile option. Hope that helps! Very Best Regards, Razzak.

