TIBDatabase Connect Error
Adalberto Baldini
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)
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).
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
And so I patrol in the valley of the shadow of the tricolor
I must fear evil. For I am but mortal and mortals can only die.
Asking questions, pleading answers from the nameless
faceless watchers that stalk the carpeted corridors of Whitehall.
(Fish)
Adalberto Baldini
"Jeff Overcash (TeamB)" <jeffov...@mindspring.com> ha scritto nel
messaggio news:484c...@newsgroups.borland.com...
The other alternative is to use Aliases which were
> 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)
news:489553f2$1...@newsgroups.borland.com...
>
> 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.
--
Wayne Niddery - TeamB (www.teamb.com)
Winwright, Inc. (www.winwright.ca)