Monday, 20 June 2016

Re: [firebird-support] Not a valid database

 

Hello Seyeong,

Tuesday, June 21, 2016, 12:52:51 PM, you wrote:

> SQL>> connect "/home/user/a.fdb" user '*******' password '**********'; 

> Statement failed, SQLSTATE = HY000
> file /home/user/a.fdb is not a valid database

> Note that the example file, employee.fdb is accessible.

> Again, the same file is perfectly accessible on Windows with FlameRobin.

My top suspicion is that you have a backup file there that you have
inadvertently named with the ."fdb" extension. I suggest you try
again, this time just making certain about those file names when you
back up and restore.

BTW, this error has nothing to do with the file name: it is raised
when the engine finds the named file but can't find a database header
page in it.

Also, Firebird doesn't care about extensions at all. ".fdb" for
databases and ".fbk" for backup files are just a convention.

Helen

__._,_.___

Posted by: Helen Borrie <helebor@iinet.net.au>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___

No comments:

Post a Comment