[SOLVED] Error "attachDatabase failed" in Firebird
lazarus / 16-Databases

----------------------------------------------------------------------
AEslabon4 · 2017-07-05 19:30

Hello everyone! 

I have a computer with Windows 7 and installed Firebird 3.0.2 Classic.
Also I installed Flamerobin 0.9.2 

I configured the Database, but when I try to open it i have the
error: 

IProvider::attachDatabase failed when loading mapping cache 

If I copy the database to a different computer, FlameRobin open the
Database with no problems. 

Did I miss something?

----------------------------------------------------------------------
AEslabon4 · 2017-07-06 00:20

I desinstall Firebird Version 3.0.2 and install Firebird Version 2.5.3
and the Database is open flawlessly!! 

Well, I have to work with this version. 

Thank You all!! 

P.S.

If any of You knows what happened, please tell me.

----------------------------------------------------------------------
taazz · 2017-07-06 00:56

as far as I'm aware the specific message has to do with the security
portion of the server. you either have the database in a folder that
the server is not allowed to open databases from there and you somehow
bypass that restriction (eg adding an alias will allow you to do that)
or some sort of problem with the users and security db. Try googling
the error message you will get a number of hits on it.

----------------------------------------------------------------------
laguna · 2017-07-06 09:39

Hi,
I have your own problem,
You can explain how you did it.
Maybe with a small example.

Thanks for everything.

----------------------------------------------------------------------
AEslabon4 · 2017-07-06 15:51

Hi Taazz and Laguna! 

Thanks for replying.  

Maybe its for the security as you comment. I was working with the
Database in Windows XP 32b without problems. But the hard disk of that
machine goes down and my client buy a new computer with Windows 7 64b
installed on it. I Try to open the Database with Version 3.0.2 of
Firebird but this problem emerges. 

I search in the Internet and found this page:
http://tracker.firebirdsql.org/browse/CORE-4899 that contain a batch
file that you can run to solve this. But I try with no positive
results. 

What I finally did was desinstall Version 3.0.2 and install Version
2.5.3 of Firebird and the Database opens without problem. 

Well, as long as I work with my Database. I decided to use Firebird
Version 2.5.3 despite of being an older Version. 

Now, I have the problem that my ODBC 32 driver doesn't work with this
version.   I have to search for a 64 version instead. 

Hope that this will help you too Laguna.

----------------------------------------------------------------------
valdir.marcos · 2017-07-06 16:44

Quote from: AEslabon4 on July 06, 2017, 05:51:04 pmMaybe its for the
security as you comment. I was working with the Database in Windows XP
32b without problems. But the hard disk of that machine goes down and
my client buy a new computer with Windows 7 64b installed on it. I Try
to open the Database with Version 3.0.2 of Firebird but this problem
emerges. 

What I finally did was desinstall Version 3.0.2 and install Version
2.5.3 of Firebird and the Database opens without problem. 

Well, as long as I work with my Database. I decided to use Firebird
Version 2.5.3 despite of being an older Version. 

So far, you should not use 2.5- files on a 3.0+ Firebird server
without a migration process:
- backup on 2.5 and restore on 3.0 (and, maybe, some fixes on your
metadata), or;
- new metadata on 3.0+ and data pump from 2.5-.

Have you read the documentation?
https://www.firebirdsql.org/en/documentation/
https://www.firebirdsql.org/en/release-notes/

Specially?
https://www.firebirdsql.org/file/documentation/reference_manuals/user_
manuals/html/qsg3-databases.html
https://www.firebirdsql.org/file/documentation/release_notes/html/en/3
_0/rnfb30-compat-initsec.html

----------------------------------------------------------------------
AEslabon4 · 2017-07-06 17:38

Hi, Marcos!! 

Thank You very much for the information!! 

I try this process. 

Best regards.

----------------------------------------------------------------------
laguna · 2017-07-10 07:10

Thanks.

Vincenzo