Subject Re: [firebird-support] hostname:databasename
Author Mark Rotteveel
On 7-9-2012 22:35, scadcam2004 wrote:
> Hi,
> Hope somebody can help me.
> Is it possible to use other than ":" to separate hostname and database name?
> My problem is this:
> I just started a project using a Microsoft Azure virtual machine in the cloud that will host a firebird database.
> To access the virtual machine you need to give a url plus port number. Like this:
> scadcam.cloudapp.net:51160 This would be the hostname.
> But when trying to access the database with scadcam.cloudapp.net:51160:employees, firebird reads up to the first ":" leaving out the port number needed to access the host.
> Is there a workaround?
> Regards,
> Héctor Ríos Mendoza
> scadcam@...
> 614 4155821, 4160317

For the Firebird library itself you simply need to use
scadcam.cloudapp.net/51160:employees

The fact that Microsoft specifies scadcam.cloudapp.net:51160 is that
almost all applications use ':' as the separator between hostname and
port. Firebird doesn't, it uses '/' as the separator. At the TCP/IP
level where the actual connection is created that distinction doesn't
even exist.

Mark
--
Mark Rotteveel