Subject All about different connection strings?
Author Thomas Steinmaurer
Hi all,

does someone know what InterBase treats as different connection
strings, which can lead to database corruption.

Surely, one combination is:

c:databases\data.gdb vs. c:\databases\data.gdb


But what about the following?

- local vs. remote connection (IP address)

e.g.: c:\databases\data.gdb vs. 127.0.0.1:c:\databases\data.gdb


- local vs. remote connection (the "real" IP address)

e.g.: c:\databases\data.gdb vs. 192.168.0.100:c:\databases\data.gdb


- local vs. remote connection (server name)

e.g.: c:\databases\data.gdb vs. localhost:c:\databases\data.gdb


- local vs. remote connection (the "real" server name)

e.g.: c:\databases\data.gdb vs. ntserver:c:\databases\data.gdb


- remote connection vs. remote connection

e.g.:

127.0.0.1:c:\databases\data.gdb vs. 192.168.0.100:c:\databases\data.gdb

or

localhost:c:\databases\data.gdb vs. 192.168.0.100:c:\databases\data.gdb

or

ntserver:c:\databases\data.gdb vs. 192.168.0.100:c:\databases\data.gdb

...


Is it simply the missing '\' in the database path, or can database
corruption happen when mixing local vs. remote connection.


Just thinking loud (or am I bored?). Thank you.


Regards,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com