[freetds] tds7_get_instance_port timed out

Gregor at HostGIS gregor at hostgis.com
Sat Mar 20 12:28:15 EDT 2010

> The connection string might be confusing PHP. Where I work we connect to SQL
> server from Ubuntu and have configured all of our connection names in our
> FreeTDS conf file.

Yeah, I tried that too ad got the same results:

Configure this:

         host = ec2-174-129-135-45.compute-1.amazonaws.com
         port = 1433
         tds version = 8.0
         instance = SQLSERVER

Try this:

$db = mssql_connect('ec2test', 'user', 'pass');

Get this:

(net.c:836):tds7_get_instance_port(, SQLSERVER)
(net.c:905):tds7_get_instance_port: timed out on try 0 of 16

> My build instructions for our setup are here

Looks pretty standard, though in my case, I used PHP's --with-mssql flag 
when configuring, rather than building an extension. Given the issues 
I've had with other DB drivers having different defines that my own PHP, 
and generating symbol errors, I thought this the best route.

Can you explain what tds7_get_instance_port() does exactly, or how I'd 
trace out what TCP port it's trying to connect? Port 1433 is open but 
other ports are not, so if it's trying to connect to some other port for 
this specific instance it may be blocked there.

HostGIS, Open Source solutions for the global GIS community
Greg Allensworth - SysAdmin, Programmer, GIS Person, Security
    Network+   Server+   A+   Security+   Linux+
    PHP   PostgreSQL   MySQL   DHTML/JavaScript/AJAX

"No one cares if you can back up — only if you can recover."

More information about the FreeTDS mailing list