[freetds] php mssql_connect() without section name in freetds.conf

jezekj at centrum.cz jezekj at centrum.cz
Sat Feb 6 08:29:12 EST 2016


Sorry I was wrong. Port is not space delimited, but comma delimited. Please try "10.98.97.96,62220". Maybe it will help.

JJ

5. února 2016 17:49:14 CET, "Muresanu A.V. (Andrei Valentin)" <andrei.muresanu at ing.ro> napsal:
>Doesn't work. It's the same as not mentioning the port at all. Tries on
>port 4000 instead:
>
>20009: "Unable to connect: Adaptive Server is unavailable or does not
>exist"
>
>log.c:196:Starting log file for FreeTDS 0.91
>        on 2016-02-05 18:46:24 with debug flags 0x4fff.
>iconv.c:330:tds_iconv_open(0x2b9bfd0, UTF-8)
>iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
>iconv.c:187:local name for UTF-8 is UTF-8
>iconv.c:187:local name for UCS-2LE is UCS-2LE
>iconv.c:187:local name for UCS-2BE is UCS-2BE
>iconv.c:349:setting up conversions for client charset "UTF-8"
>iconv.c:351:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
>iconv.c:391:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
>iconv.c:394:tds_iconv_open: done
>net.c:205:Connecting to 10.98.97.95 port 4000 (TDS version 7.1)
>net.c:270:tds_open_socket: connect(2) returned "Operation now in
>progress"
>net.c:316:tds_open_socket() failed
>util.c:331:tdserror(0x2a89fa0, 0x2b9bfd0, 20009, 115)
>dblib.c:7906:dbperror(0x2b9b5f0, 20009, 115)
>dblib.c:7958:20009: "Unable to connect: Adaptive Server is unavailable
>or does not exist"
>dblib.c:7979:"Unable to connect: Adaptive Server is unavailable or does
>not exist", client returns 2 (INT_CANCEL)
>util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
>util.c:384:tdserror: returning TDS_INT_CANCEL(2)
>dblib.c:1424:dbclose(0x2b9b5f0)
>dblib.c:258:dblib_del_connection(0x7fe324a6b1a0, 0x2b9bfd0)
>mem.c:615:tds_free_all_results()
>dblib.c:305:dblib_release_tds_ctx(1)
>dblib.c:5859:dbfreebuf(0x2b9b5f0)
>dblib.c:724:dbloginfree(0x2b9b020)
>dblib.c:1493:dbexit(void)
>dblib.c:305:dblib_release_tds_ctx(1)
>
>-----Original Message-----
>From: FreeTDS [mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of
>jezekj at centrum.cz
>Sent: Friday, February 05, 2016 6:19 PM
>To: FreeTDS Development Group
>Subject: Re: [freetds] php mssql_connect() without section name in
>freetds.conf
>
>Not sure, but in old Sybase times port has been delimited by space.
>i.e. "10.98.97.96 62220". Maybe I'm totally wrong here, but give it a
>try.
>
>JJ
>
>5. února 2016 10:27:12 CET, "Muresanu A.V. (Andrei Valentin)"
><andrei.muresanu at ing.ro> napsal:
>>Hi,
>>
>>anybody have any idea with the following ?
>>
>>Does not work, gives 'Unknown host machine name'. Even with tds
>version 
>>= 7.0... 7.1, 8, etc..:
>>
>>$link = mssql_connect("10.98.97.96:62220", 'user', 'pass');
>>
>>Works because there is a section in freetds.conf named 'dasdswh':
>>
>>$link = mssql_connect('dasdswh', 'user', 'pass');
>>
>>$ php -v
>>PHP 5.5.21 (cli) (built: Jun 10 2015 05:26:44) Copyright (c) 1997-2014
>
>>The PHP Group Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend 
>>Technologies with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2014, by
>
>>Zend Technologies
>>
>>Trace log:
>>
>>16:55:35.585240 15567 (log.c:196):Starting log file for FreeTDS 0.91
>>        on 2016-02-04 16:55:35 with debug flags 0xffff.
>>16:55:35.585295 15567 (iconv.c:330):tds_iconv_open(0x2569f10, UTF-8)
>>16:55:35.585508 15567 (iconv.c:187):local name for ISO-8859-1 is
>>ISO-8859-1
>>16:55:35.585528 15567 (iconv.c:187):local name for UTF-8 is UTF-8
>>16:55:35.585542 15567 (iconv.c:187):local name for UCS-2LE is UCS-2LE
>>16:55:35.585560 15567 (iconv.c:187):local name for UCS-2BE is UCS-2BE
>>16:55:35.585578 15567 (iconv.c:349):setting up conversions for client 
>>charset "UTF-8"
>>16:55:35.585590 15567 (iconv.c:351):preparing iconv for "UTF-8" <-> 
>>"UCS-2LE" conversion
>>16:55:35.585610 15567 (iconv.c:391):preparing iconv for "ISO-8859-1"
>><-> "UCS-2LE" conversion
>>16:55:35.585635 15567 (iconv.c:394):tds_iconv_open: done
>>16:55:35.585647 15567 (util.c:331):tdserror(0x245d490, 0x2569f10, 
>>20013, 0)
>>16:55:35.585666 15567 (dblib.c:7906):dbperror(0x2569530, 20013, 0)
>>16:55:35.585681 15567 (dblib.c:7958):20013: "Unknown host machine
>name"
>>16:55:35.585717 15567 (dblib.c:7979):"Unknown host machine name", 
>>client returns 2 (INT_CANCEL)
>>16:55:35.585734 15567 (util.c:361):tdserror: client library returned
>>TDS_INT_CANCEL(2)
>>16:55:35.585751 15567 (util.c:384):tdserror: returning
>>TDS_INT_CANCEL(2)
>>16:55:35.585766 15567 (login.c:417):IP address pointer is empty
>>16:55:35.585776 15567 (login.c:419):Server 10.98.97.96:62220 not
>found!
>>16:55:35.585795 15567 (dblib.c:1424):dbclose(0x2569530)
>>16:55:35.585815 15567
>>(dblib.c:258):dblib_del_connection(0x7f78f16cd800, 0x2569f10)
>>16:55:35.585862 15567 (mem.c:615):tds_free_all_results()
>>16:55:35.585890 15567 (dblib.c:305):dblib_release_tds_ctx(1)
>>16:55:35.585909 15567 (dblib.c:5859):dbfreebuf(0x2569530)
>>16:55:35.592809 15567 (dblib.c:724):dbloginfree(0x2569510)
>>16:55:35.594342 15567 (dblib.c:1493):dbexit(void)
>>16:55:35.594378 15567 (dblib.c:305):dblib_release_tds_ctx(1)
>>
>>----------------------------------------------------------------
>>ATTENTION:
>>The information in this e-mail is confidential and only meant for the 
>>intended recipient. If you are not the intended recipient , don't use 
>>or disclose it in anyway. Please let the sender know and delete the 
>>message immediately.
>>-----------------------------------------------------------------------
>>-------------------------------
>>
>>
>>_______________________________________________
>>FreeTDS mailing list
>>FreeTDS at lists.ibiblio.org
>>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>--
>Odesláno z mého telefonu s Androidem pomocí pošty K-9 Mail. Omluvte
>prosím moji stručnost.
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>------------------------------------------------------------------------------------------------------
>ATTENTION:
>The information in this e-mail is confidential and only meant for the
>intended recipient. If you are not the intended recipient , don't use
>or disclose it in anyway. Please let the sender know and delete the
>message immediately.
>------------------------------------------------------------------------------------------------------
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds

-- 
Odesláno z mého telefonu s Androidem pomocí pošty K-9 Mail. Omluvte prosím moji stručnost.


More information about the FreeTDS mailing list