FreeTDS - PHP - Mac OS X Leopard Server

Kelvin Howard <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
I am I am having the same issue on OSX Leopard. I seem to be connecting to
the server but I am receiving an end EOF from the server when attempting to
login. I have tds version set to 7.0 using entropy (which has freetds built
in now and is using php 5.3.0).

here is a tail of freetds.log

iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character
set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:210:Connecting to 152.44.159.220 port 1433 (TDS version 7.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:303:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
util.c:334:tdserror(0x102f82f40, 0x102f8a280, 20017, 0)
dblib.c:7782:dbperror(0x100a31a00, 20017, 0)
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
token.c:316:looking for login token, got 0()
token.c:108:tds_process_default_tokens() marker is 0()
token.c:111:leaving tds_process_default_tokens() connection dead
util.c:334:tdserror(0x102f82f40, 0x102f8a280, 20002, 0)
dblib.c:7782:dbperror(0x100a31a00, 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)
dblib.c:1372:dbclose(0x100a31a00)
dblib.c:256:dblib_del_connection(0x102dacb00, 0x102f8a280)
mem.c:563:tds_free_all_results()

php connection script

$serverName = 'server';
$user = 'sa';
$pass = 'pass';

if(function_exists('mssql_connect')) {
$c = mssql_connect($serverName, $user, $pass);
echo "mssql_connect($serverName, $user, $pass): ". ($c ? 'Success' :
'Error') . "
";
mssql_close($c);
sleep(1);
}

Thanks,

Kelvin
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.