TIBDatabase Connect Error

[Adalberto Baldini]

I do this assignement
IBDB_Connections.DatabaseName :=
'\\Hppav_adal\hp_d\FI_Applic\Conness\CONNECTIONS.IB'

(where 'hp_d' is the name of a shared drive)

when I perform Connect I get this error :

Project ... raised an exception class EIBInterbaseError with message
'I/O error for file "\hp_d\FI_Applic\Conness\CONNECTIONS.IB"'
Error while trying to open file unknown Win32 error 3

Server name is cut off, but after that system error in debug, my program
raises exception error message showing the
IBDB_Connections.DatabaseName and the Server name is still there.

testing If FileExists('\\Hppav_adal\hp_d\FI_Applic\Conness\CONNECTIONS.IB')
... I get True

As file is in my computer, using 'd:\FI_Applic\Conness\CONNECTIONS.IB' is
ok,
but I would hide my direct path .. (seen discussion in forum)

Thanks
Adalberto

[Jeff Overcash (TeamB)]

Post by Adalberto Baldini
I do this assignement
IBDB_Connections.DatabaseName :=
'\\Hppav_adal\hp_d\FI_Applic\Conness\CONNECTIONS.IB'
(where 'hp_d' is the name of a shared drive)
Project ... raised an exception class EIBInterbaseError with message
'I/O error for file "\hp_d\FI_Applic\Conness\CONNECTIONS.IB"'
Error while trying to open file unknown Win32 error 3
Server name is cut off, but after that system error in debug, my
program raises exception error message showing the
IBDB_Connections.DatabaseName and the Server name is still there.
testing If
FileExists('\\Hppav_adal\hp_d\FI_Applic\Conness\CONNECTIONS.IB')
... I get True
As file is in my computer, using 'd:\FI_Applic\Conness\CONNECTIONS.IB' is
ok,
but I would hide my direct path .. (seen discussion in forum)
Thanks
Adalberto

You can't use shared directories. In fact it is a major security flaw of yours
if you are sharing the directory that the IB database is in. you must connect
using the server local path. The other alternative is to use Aliases which were
introduced in IN 7.5 (IIRC).

[Adalberto Baldini]

"Jeff Overcash (TeamB)" <***@mindspring.com> ha scritto nel
messaggio news:***@newsgroups.borland.com...

The other alternative is to use Aliases which were

Post by Jeff Overcash (TeamB)
introduced in IN 7.5 (IIRC).

Could you give me some additional details about Aliases.
Only documentation I found is about to Backup Database in IBConsole.

Thanks
Adalberto Baldini

[Wayne Niddery (TeamB)]

Post by Adalberto Baldini
Could you give me some additional details about Aliases.
Only documentation I found is about to Backup Database in IBConsole.

Some information on managing aliases on the server side is contained in an
article by Bill Todd here: http://conferences.codegear.com/article/33246.

To use an alias is easy, just use it anywhere you would currently specify a
database path in a connection string. E.g if you have created an alias
called "Emp' as in the example then to connect to that database from a
client:

Where it would've been
yourserver:c:\ibdb\employee.gdb
you can now use:
yourserver:Emp

Now anyone able to see you connection string knows only the name of the
server you are connecting to, but not the path or name of the database. To
get that they would have to get access to the server itself and know how to
query the admin.ib database or use gsec.

[quinn]

Page 94, InterBase 2007 Operation Guide Manual.

Post by Adalberto Baldini
Could you give me some additional details about Aliases.
Only documentation I found is about to Backup Database in IBConsole.
Thanks
Adalberto Baldini