Use DBUTIL DETACH

:DBUTIL
>> DETACH MMSDB3

DBUTIL will also show an error. But it will in reality have done enough to
the database flags to have detached the database. You should then be able to
continue on as normal (attaching from the correct account or whatever).


-----Original Message-----
From: Jim Phillips [mailto:[log in to unmask]]
Sent: Tuesday, September 16, 2003 9:44 AM
To: [log in to unmask]
Subject: SQL Detach Failing


We have copied (using MPEX) a database from one
account to another.  The original database is enabled
for SQL access and attached to a DBE.  When we try to
detach the copied database it fails thusly:

>>SET TURBODB MMSDB3
>>SET SQLDBE MMSDBSQ
>>DETACH
ALLBASE/SQL CONNECT command failed (ATCERR 32351).
  Attempt to create a file in an account other than
the DBCon's.   (DBERR 3104)


How do I get this database detached from the DBE?

Jim

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *