gbak restore of InterBase database under Vista

Jack Mason

unread,

May 26, 2008, 8:34:14 PM5/26/08

to

I have a backup file, customer.bak, that I want to use to create a new
copy of the database. My gbak command is:

gbak -C -V -O -user SYSDBA -pas masterkey
C:\backups\snellville\customer.bak C:\backups\snellville\customer

The directory C:\backups\snellville exists and has the file
"customer.bak" in it. There is no file "customer" in the directory.

Here is what I get when the command is executed:

gbak: opened file C:\backups\snellville\customer.bak
gbak: transportable backup -- data in XDR format
gbak: backup file is compressed
gbak: ERROR: unavailable database
gbak: ERROR: failed to create database C:\backups\snellville\customer
gbak: Exiting before completion due to errors

I have tried it without the -O with the same results. Is there
something basic I am doing wrong? I have write access to both the
directories C:\backups and C:\backups\snellville because I am able to
save a file (restore.bat) in either directory using notepad.

Thanks for any help.

Thomas Steinmaurer

unread,

May 27, 2008, 4:30:46 AM5/27/08

to

Try to use a TCP/IP connection for the restored database by putting
'localhost' in front of the connection string, e.g.:

gbak -C -V -O -user SYSDBA -pas masterkey

C:\backups\snellville\customer.bak localhost:C:\backups\snellville\customer

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com

Quinn Wildman (CodeGear Developer Support)

unread,

May 27, 2008, 11:15:54 AM5/27/08

to

The unavailable database error means the InterBase server is not running.

Jack Mason

unread,

May 27, 2008, 10:18:46 PM5/27/08

to

Thanks for the input, Quinn. However, The InterBase server is running.
I believe Thomas has his finger on it... Vista will not allow
InterBase access at all on the localserver unless TCP/IP is used.

I will try his suggestion, but thanks again for your input.

Jack Mason

unread,

May 27, 2008, 10:20:32 PM5/27/08

to

Thanks, Thomas. I do believe you have put your finger on the problem.
It had not occurred to me that gbak would use the localserver without
using TCP/IP. Vista does not allow InterBase access for any database on

Jack Mason

unread,

May 27, 2008, 10:21:54 PM5/27/08

to

Yep, that did it.
Thanks again.

dan palley

unread,

May 28, 2008, 11:58:38 AM5/28/08

to

"Jack Mason" <jack...@mindspring.com> wrote in message
news:483cc106$1...@newsgroups.borland.com...

> Thanks for the input, Quinn. However, The InterBase server is running. I
> believe Thomas has his finger on it... Vista will not allow InterBase
> access at all on the localserver unless TCP/IP is used.

IB 2007 SP2 local connections work in Vista; earlier versions did not.

Dan

Message has been deleted

timothy...@gmail.com

unread,

Nov 6, 2015, 1:43:06 AM11/6/15

to

вторник, 27 мая 2008 г., 11:30:46 UTC+3 пользователь Thomas Steinmaurer написал:

Thomas, thank you very much!