Thanks for the clarification. ----- Original Message ----- From: "Emmitt Dove" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, November 03, 2004 9:08 AM Subject: [RBG7-L] - Re: odbc
> Jan, > > The database wouldn't be read-only - just the schema in your main database. > > You would have full access to the SATTACHed tables and data. > > >Thanks Emmit & Razzak, > > > >I don't think I can use that as I will need to be able to modify & add rows > >to the connected database so a read-only doesn't help. > > > >Jan > > > >----- Original Message ----- > >From: "A. Razzak Memon" <[EMAIL PROTECTED]> > >To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > >Sent: Wednesday, November 03, 2004 6:39 AM > >Subject: [RBG7-L] - Re: odbc > > > > > > > > > > At 08:00 AM 11/3/2004 -0500, Emmitt Dove wrote: > > > > > > >What you can also do is run with STATICDB ON, and > > > >then SCONNECT/SATTACH as required. This makes the > > > >SATTACH temporary, and is automatically removed > > > >when you disconnect the database. > > > > > > > > > And if you need to suppress that message: > > > > > > "Database Schema is Read-Only" > > > > > > You can use the following technique: > > > > > > DISCONNECT > > > SET STATICDB ON > > > SET ERROR MESSAGE 2495 OFF > > > CONNECT dbname > > > SET ERROR MESSAGE 2495 ON > > > RETURN > > > > > > That is your tip of the day! > > > > > > Very Best R:egards, > > > > > > Razzak. > > > > > > > > Emmitt Dove > Manager, DairyPak Business Systems > Blue Ridge Paper Products, Inc. > 40 Lindeman Drive > Trumbull, CT 06611 > (203) 673-2231 > [EMAIL PROTECTED] > [EMAIL PROTECTED] > >
