Skip to Content.
Sympa Menu

freetds - Re: [freetds] tds7_get_instance_port timed out

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Gregor at HostGIS <gregor AT hostgis.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] tds7_get_instance_port timed out
  • Date: Sat, 20 Mar 2010 09:53:18 -0700

Daniel Fazekas wrote:
Not TCP, the automatic port discovery for named instances uses UDP port 1434.

OK, thank you for clarifying. Interesting idea they had there.


Considering you are already sure the server is listening on TCP 1433,
> you have no need for that or specifying the instance name.
Just remove the "instance=" line.

Okay... and, darn. Still not working.

freetds.conf:

[ec2test]
host = ec2-174-129-135-45.compute-1.amazonaws.com
port = 1433
tds version = 8.0

PHP code:

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

And result from the freetds log:

A few packets were sent, then this:

(dblib.c:7835):20017: "Unexpected EOF from the server"
(dblib.c:7856):"Unexpected EOF from the server", client returns 2 (INT_CANCEL)
(util.c:368):tdserror: client library returned TDS_INT_CANCEL(2)
(util.c:389):tdserror: returning TDS_INT_CANCEL(2)
(util.c:162):Changed query state from IDLE to DEAD
(net.c:1292):handshake failed
(util.c:334):tdserror(0xd4bef0, 0xe3ad60, 20002, 0)
(dblib.c:7782):dbperror(0xe3a3e0, 20002, 0)
(dblib.c:7835):20002: "Adaptive Server connection failed"
(dblib.c:7856):"Adaptive Server connection failed", client returns 2 (INT_CANCEL)
(util.c:368):tdserror: client library returned TDS_INT_CANCEL(2)
(util.c:389):tdserror: returning TDS_INT_CANCEL(2)


Is this a bit further along? What "tds version" should I be using for SQL Server 2008?

--
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."




Archive powered by MHonArc 2.6.24.

Top of Page