Is it possible to rename a named database the uses referential integrity?

I'm using P.SQL 8.6 Workgroup Engine on WinXP.
Using PCC, I tried deleting the DSN then renaming the database. This
appears to work. I created a new DSN, but when I try to access the database
using the new name, I get referential integrity errors.

Is there any way to make this work?

Thanks,
- Greg

It sounds like the data file is bound to the old database name.
In that case you have to put it back in the old database then unbind
it. At a minimum remove security if enabled and in Maintain Named
Database uncheck the "Bound" box for the database. It is possible
that there are some actual SQL constraints on the table. If there are
SQL constraints they have to be dropped also.
After it is unbound you can move or rename until your heart is
content.

Leonard

On Wed, 3 Nov 2004 15:05:20 -0800, "Greg Doherty" <NoSpam (AT) nospam (DOT) com>
wrote: