Database Exists but can not be opened

bhaskar_dave · Post by **bhaskar_dave** » Fri Jan 04, 2002 4:44 pm

Hi ,
I have two database in texis. dbone and dbtwo. While crawling thru dbtwo database it gives me error of saying "Database dbtwo exists, but can not be opened"

The command I am using is :
gw -dE:\TexisDatabase\dbtwo -s "select * from PRODUCT_CONTENT"

This command is just a sample example. It doesn't even let me wipe the database.
But it allows me to crawl thru the database dbone

I have created both the database in same location which is E:\TexisDatabase\dbone and E:\TexisDatabase\dbtwo.

Pls. help

Awaiting reply,

Post by **mark** » Fri Jan 04, 2002 5:36 pm

You probably somehow created dbtwo as the wrong userid, so now that gw is running as the correct userid it can't access it. Compare the ownerships and permissions of the two directories and the files in them.

bhaskar_dave · Post by **bhaskar_dave** » Fri Jan 04, 2002 5:55 pm

Hi Mark,
Thanks for reply.
I Don't get it what you are saying !!!
Ownerships and permissions are same for both direcotories. files are diff. While creating database what userid does it take by default ?

Awaiting reply,

Post by **mark** » Fri Jan 04, 2002 6:05 pm

You were going to -wipe it anyhow. Just delete the whole directory and everything in it and recreate it with
gw -create -dE:\TexisDatabase\dbtwo