Subject | RE: [IB-Architect] Re: Is it _really_ necessary to expose the location of the database file? |
---|---|
Author | Bill King |
Post date | 2000-08-08T13:46:59Z |
you can get this functionality at the moment using windows networking.
interbase is kind enough to detect that the file is residing on another
machine, and redirects all requests for that database through to the correct
server. (i found this one out the hard way).
so if you map \\server\servershare to s: for example. then connecting to
s:\test.gdb will actually connect to the server's interbase server! path
hiding.....+full security if the share is sitting on an NT box.
Bill King.
-----Original Message-----
From: ib-architect-admin@... [mailto:ib-architect-admin@...]On
Behalf Of Dennis Fantoni
Sent: Tuesday, 8 August 2000 6:51 PM
To: ib-architect@...
Subject: [IB-Architect] Re: Is it _really_ necessary to expose the
location of the database file?
answer to a msg from mers.interbase.list..
I Agree 100% on this one. It is keeping me from changing names on my
databasefiles bc i would have to update all the clients, which should not be
neccesary.
Someone with time to spare might look into some kind of alias system. It
could be implemented as some kind of parser method that recreates the path
from the connectstring. if a client connects with a string like
servername:aliasname (no drive at the start, exact syntax to be discussed)
the new feature should figure out that an alias is being specified, and look
up the physical path from an alias list. The physical connect string could
then be sent to the old server code that connects to the database file. A
small API should then be developed. add alias, remove alias, alter alias,
and get all aliases. Someone then should make a cmdline app. to do these
changes, and someone might do a gui app too. I am currently only fluent in
Delphi, so i can't really do any programming besideds a windows gui.
Dennis
Regards
Dennis Fantoni
df@...
dennis@...
Senior developer (Delphi interbase ) at Danasoft A/S - www.danasoft.dk
_______________________________________________
Ib-architect mailing list
Ib-architect@...
http://mers.com/mailman/listinfo/ib-architect
To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com
interbase is kind enough to detect that the file is residing on another
machine, and redirects all requests for that database through to the correct
server. (i found this one out the hard way).
so if you map \\server\servershare to s: for example. then connecting to
s:\test.gdb will actually connect to the server's interbase server! path
hiding.....+full security if the share is sitting on an NT box.
Bill King.
-----Original Message-----
From: ib-architect-admin@... [mailto:ib-architect-admin@...]On
Behalf Of Dennis Fantoni
Sent: Tuesday, 8 August 2000 6:51 PM
To: ib-architect@...
Subject: [IB-Architect] Re: Is it _really_ necessary to expose the
location of the database file?
answer to a msg from mers.interbase.list..
I Agree 100% on this one. It is keeping me from changing names on my
databasefiles bc i would have to update all the clients, which should not be
neccesary.
Someone with time to spare might look into some kind of alias system. It
could be implemented as some kind of parser method that recreates the path
from the connectstring. if a client connects with a string like
servername:aliasname (no drive at the start, exact syntax to be discussed)
the new feature should figure out that an alias is being specified, and look
up the physical path from an alias list. The physical connect string could
then be sent to the old server code that connects to the database file. A
small API should then be developed. add alias, remove alias, alter alias,
and get all aliases. Someone then should make a cmdline app. to do these
changes, and someone might do a gui app too. I am currently only fluent in
Delphi, so i can't really do any programming besideds a windows gui.
Dennis
> Thanks for the reply Claudio. I was not talking about a remote share tothe database file. What I
> meant was that the client connection string includes information thatshould be private to the
> server. For example, I have a test database which is located atc:\ib\test01.gdb (on the [NT]
> server). I would expect to be able to configure an alias for thisdatabase, on the server, say
> "mytest". The connection string would then look something like:could do so, change the
>
> testserver:mytest
>
> If I later wanted to change the actual location of test01.gdb, then I
> details of the alias on the server, and no client configurationinformation would need to be
> changed.both at the server and in
>
> At the moment, unless I have missed something, the connection string is:
>
> testserver:c:\ib\test01.gdb
>
> which means that the actual location of the database file is configured
> each client.database file changes, you
>
> Unless I have missed something obvious, if the actual location of the
> have to change all the client configurations (notwithstanding filealiasing using links, etc, which
> is a file system work-around to the problem).--
Regards
Dennis Fantoni
df@...
dennis@...
Senior developer (Delphi interbase ) at Danasoft A/S - www.danasoft.dk
_______________________________________________
Ib-architect mailing list
Ib-architect@...
http://mers.com/mailman/listinfo/ib-architect
To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com