[unixODBC-support] can not connect through php

jwan at ea.ucla.edu jwan at ea.ucla.edu
Fri Apr 23 18:49:27 BST 2010


Nick,

Thanks for responding:

I did that.  The first part appear has error in log as follow:  ( if I
should send the whole file let me know)

Part I: when run from browser (php)
--------------------------------------------------------------------------------------------------------------------
[ODBC][13567][SQLConnect.c][3549]
  Entry:
   Connection = 0x2b16f1098720
   Server Name = [srdbiop][length = 7 (SQL_NTS)]
   User Name = [eleopi][length = 6 (SQL_NTS)]
   Authentication = [********][length = 8 (SQL_NTS)]
  UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
  DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to data source


Part II: when run from the server using isql
--------------------------------------------------------------------------------------------------------------------
[ODBC][19988][1272044029.210493][SQLConnect.c][3614]
  Entry:
   Connection = 0x8e90a0
   Server Name = [srdbiop][length = 7 (SQL_NTS)]
   User Name = [eleopi][length = 6 (SQL_NTS)]
   Authentication = [********][length = 8 (SQL_NTS)]
  UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

Part III: when run tsql, log from 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 "UTF-8" character set
iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:210:Connecting to xxx.xx.xx.xx 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
Part IV: when connect using osql

----------------------------------------------------------------------------------------------------------

[ODBC][20358][__handles.c][444]
  Exit:[SQL_SUCCESS]
   Environment = 0x29a9320
[ODBC][20358][SQLAllocHandle.c][345]
  Entry:
   Handle Type = 2
   Input Handle = 0x29a9320
[ODBC][20358][SQLAllocHandle.c][463]
  Exit:[SQL_SUCCESS]
   Output Handle = 0x29a9980
[ODBC][20358][SQLConnect.c][3549]
  Entry:
   Connection = 0x29a9980
   Server Name = [srdbiop][length = 7 (SQL_NTS)]
   User Name = [eleopi][length = 6 (SQL_NTS)]
   Authentication = [********][length = 8 (SQL_NTS)]
  UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
[ODBC][20358][SQLConnect.c][4123]
  Exit:[SQL_SUCCESS]
---------------------------------------------------------------------------------------------------------------------

Thanks



On Fri, Apr 23, 2010 at 12:28 AM, Nick Gorham <nick.gorham at easysoft.com>wrote:

> jwan at ea.ucla.edu wrote:
>
>> Thank, I did not install the gui, how do I enable the driver manger
>> logging?
>>
>
> in odbcinst.ini
>
> [ODBC]
> Trace = Yes
> TraceFile = /tmp/sql.log
>
>
> --
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20100423/86b6147a/attachment.html>


More information about the unixODBC-support mailing list