Hi Mark,
 
Sounds nice but still cannot connect with scadcam.cloudapp.net/51160:employees
Is this / to indicate the port firebird uses or for the port to get access to the host?
If I enter into isql inside the virtual machine, I try the following..
a.  connect employees        (works fine)
b.  connect localhost:employees  (works fine)
c.  connect localhost/3050:employees (works fine)
d.  connect localhost/3060:employees (fails with sqlstate=08006)
 
I have turned off the firewall in both sides but still refuses the connection with sqlstate=08004 
Because of point c above, I think / is only to indicate the port firebird uses but not to specify the port to get access to virtual machine. Is there something like a cascading of ports?  From within the Windows Azure, scadcam.cloudapp.net gets you to your "environment" (still not familiar), but you still need to give the port to take you to one of possibly several virtual machines and then specify the firebird port (really not needed because is using the default firebird port).
Does it sound rational?
 
Regards,
Hector Rios


________________________________
From: Mark Rotteveel <mark@...>
To: firebird-support@yahoogroups.com
Sent: Saturday, September 8, 2012 3:23 AM
Subject: Re: [firebird-support] hostname:databasename



 

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
> mailto:scadcam%40gmail.com
> 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



[Non-text portions of this message have been removed]