FreeTDS Development Group

["Brian Morton" <bmorton AT secureworks.com>]

It looks like mssql_connect is trying to use ctlib (which should work).
But it doesn't appear to be using your FreeTDS.  I would say check your
login.  It is probably actually failing.  Try connecting via tsql on the
command line.  Also, make sure you add the port 1433
(mssql_connect(serverip:1433,...) in your PHP call.  I have found that
it explicitly requires this.

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Oswaldo Otero
Sent: Wednesday, August 30, 2006 10:35 AM
To: freetds AT lists.ibiblio.org
Subject: [freetds] PHP5-MsSQL Error

 Hello everybody.
 
 I am trying to reach a MSSQL server via PHP but I had the follow
error.
 
 /*************************************
 Warning: mssql_connect() [function.mssql-connect]: Sybase: Client
 message: Read from SQL server failed. (severity 78)
 in /var/www/phpinfo.php on line 12
 
 Warning: mssql_connect() [function.mssql-connect]: Sybase: Client
 message: Login incorrect. (severity 78) in /var/www/phpinfo.php on
line
 12
 
 Warning: mssql_connect() [function.mssql-connect]: Sybase: Unable to
 connect in /var/www/phpinfo.php on line 12
 
 Warning: mssql_select_db(): supplied argument is not a valid
Sybase-Link
 resource in /var/www/phpinfo.php on line 13
 
 Warning: mssql_query(): supplied argument is not a valid Sybase-Link
 resource in /var/www/phpinfo.php on line 15
 The field number one is:
 Warning: mssql_result(): supplied argument is not a valid Sybase
result
 resource in /var/www/phpinfo.php on line 17
 **************************************/
 
 My system is running Debian Sarge with PHP5 and Freetds-stable(I just
 downloaded it two days ago). I didn't compiled from the regular PHP
 sources instead, what I did was get the source from the Debian package
 and the I modified the rules in the Debian packages to build into the
 MSSQL dynamic library.
 
 As you guys know, this MSSQL PHP library is using FreeTDS. But I am
 having the follow in the tds.log
 
 
 /*************************************
 Starting log file with debug level 99.
 2006-08-30 05:55:55.524213 iconv will convert client-side data to the
 "ANSI_X3.4-1968" character set
 2006-08-30 05:55:55.528972 Connecting addr 10.1.1.12 port 1433 with
TDS
 version 7.0
 2006-08-30 05:55:55.529750 inside tds_process_login_tokens()
 Received header @ 2006-08-30 05:55:55.530652
 0000  04 01 00 d8 00 00 01 00                            |........|
 
 
 Received packet @ 2006-08-30 05:55:55.530719
 0000  aa c4 00 14 48 00 00 01  0e 5c 00 4c 00 6f 00 67
 |....H... .\.L.o.g|
 0010  00 69 00 6e 00 20 00 66  00 61 00 69 00 6c 00 65
 |.i.n. .f .a.i.l.e|
 0020  00 64 00 20 00 66 00 6f  00 72 00 20 00 75 00 73
 |.d. .f.o .r. .u.s|
 0030  00 65 00 72 00 20 00 27  00 28 00 6e 00 75 00 6c
 |.e.r. .' .(.n.u.l|
 0040  00 6c 00 29 00 27 00 2e  00 20 00 52 00 65 00 61
 |.l.).'.. . .R.e.a|
 0050  00 73 00 6f 00 6e 00 3a  00 20 00 4e 00 6f 00 74
 |.s.o.n.: . .N.o.t|
 0060  00 20 00 61 00 73 00 73  00 6f 00 63 00 69 00 61
 |. .a.s.s .o.c.i.a|
 0070  00 74 00 65 00 64 00 20  00 77 00 69 00 74 00 68
 |.t.e.d.  .w.i.t.h|
 0080  00 20 00 61 00 20 00 74  00 72 00 75 00 73 00 74
 |. .a. .t .r.u.s.t|
 0090  00 65 00 64 00 20 00 53  00 51 00 4c 00 20 00 53
 |.e.d. .S .Q.L. .S|
 00a0  00 65 00 72 00 76 00 65  00 72 00 20 00 63 00 6f
 |.e.r.v.e .r. .c.o|
 00b0  00 6e 00 6e 00 65 00 63  00 74 00 69 00 6f 00 6e
 |.n.n.e.c .t.i.o.n|
 00c0  00 2e 00 00 00 00 00 fd  02 00 00 00 00 00 00 00
 |........ ........|
 
 
 2006-08-30 05:55:55.530898 inside tds_process_default_tokens() marker
is
 aa(ERROR)
 2006-08-30 05:55:55.531119 inside ct_con_props() action = CS_GET
 property = 9108
 2006-08-30 05:55:55.531175 inside tds_process_default_tokens() marker
is
 fd(DONE)
 2006-08-30 05:55:55.531218 inside tds_process_end() more_results = 0,
 was_cancelled = 0
 2006-08-30 05:55:55.531240 inside tds_process_default_tokens() setting
 state to COMPLETED
 Sending packet @ 2006-08-30 05:55:55.531402
 0000  01 01 00 22 00 00 01 00  73 00 65 00 6c 00 65 00   |..."....
 s.e.l.e.|
 0010  63 00 74 00 20 00 40 00  40 00 73 00 70 00 69 00   |c.t. .@.
 @.s.p.i.|
 0020  64 00                                              |d.|
 
 
 2006-08-30 05:55:55.531718 processing result tokens.  marker is  0()
 2006-08-30 05:55:55.531754 inside tds_process_default_tokens() marker
is
 0()
 2006-08-30 05:55:55.531773 leaving tds_process_default_tokens()
 connection dead
 2006-08-30 05:55:55.531791 tds_set_spid() failed
 2006-08-30 05:55:55.531804 leaving tds_process_login_tokens()
returning
 0
 2006-08-30 05:55:55.532050 leaving ct_connect() returning 0
 2006-08-30 05:55:55.532136 inside ct_con_drop()
 
 **************************************/
 
 If you guys have any clue about how to solve this issue???/
-- 
Oswaldo Otero <oswaldo AT originalimpressions.com>

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds