Community
Showing results for 
Search instead for 
Do you mean 
Reply
Accepted Solution

unable to open database.

Tuned Listener
Posts: 25
Country: United States

Re: unable to open database.

ch1p,

thanks for your response. I did as you suggested. when I run the open existing database under the ADF file extension I get an error saying the database name already exists. Checking in actdiag, the database is in recovery but in a different folder. Act for windows 8.

Bronze Elite Contributor
Posts: 1,521
Country: United_Kingdom

Re: unable to open database.

OK

 

Does the database listed in the other folder have a size against it or is it zero in ACTDIAG?

 

If it has a size take a look at the folder indicated, is there a database in there? If so try the rename PAD option again and try to open the .adf file for this database.

 

 

Tuned Listener
Posts: 25
Country: United States

Re: unable to open database.

the size is zero.

Solution
Accepted by topic author kelleym1
‎04-11-2017 05:29 AM
Bronze Elite Contributor
Posts: 1,521
Country: United_Kingdom

Re: unable to open database.

[ Edited ]

Go to this thread and follow the instructions to remove the zero sized database.

 

http://kb.act.com/app/answers/detail/a_id/38647

 

The syntax must be followed exactly for it to work.

 

Once removed go back to my original suggestion below.

 

 

Now that you  can create a database we know that SQL is running.

 

I know you did this before but please try again the following -

 

Find the .PAD file you database and rename .OLD

 

Now in ACT select File - Open Share Database - (Ignore database in the list) Click Browse for Database

 

At bottom right change by selecting from  PAD to ADF file type.

 

Now browse to your database and try and open it.

.

 

 

Tuned Listener
Posts: 25
Country: United States

Re: unable to open database.

many thanks to Gary, Roy and ch1p. You all saved me. The database is back, missing a few pieces (1,000) of them but functioning \Thanks

Copper Contributor
Posts: 19
Country: USA

Re: unable to open database. Ver 19.2.146.0 update 4

I updated Windows 10 as computer request.

 

Now I get same message as noted on this help link.

 

I ran the ResetSQL as posted on this thread but it did not unlock pad file.

 

Help please.

 

Thanks.

 

Copper Contributor
Posts: 19
Country: USA

Re: unable to open database.

I'm having same problems.

 

I ran the ResetSQL - no luck opening database.

 

Then I renamed SQL.pad to old.

Tried opening database & same error message - could not be access...  ck network connection (this is single user laptop)... maybe necessary to disarm firewall softwall (same firewall no changes).

 

Help Thanks!!!

 

Copper Contributor
Posts: 19
Country: USA

Re: unable to open database.

Got it working.

 

I opened all 4 of the SQL Server files & click restart, then restart my computer. Took 3 attempts & the 3rd worked.

 

happy camper now!

 

 

Highlighted
Administrator
Posts: 1,372
Country: United_Kingdom

Re: unable to open database.

Thanks for the info bearcat! Glad to hear you resolved the issue Smiley Happy