Skip to Content.
Sympa Menu

freetds - [freetds] FREETDS WITH ODBC NOT WORKING WITH PHP5

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Riley Griffin" <riley_396 AT hotmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] FREETDS WITH ODBC NOT WORKING WITH PHP5
  • Date: Wed, 06 Jun 2007 11:33:35 -0500

Hello everyone, I have a problem that sounds similar to a message posted a few days ago but I believe the solution will be quite different. I am trying to use odbc connections in php scripts on an apache server to access a mssql server. I am running Centos5. My php version is 5.1.6, my apache version is 2.2.3 and my FreeTDS version is 0.64. I am able to use isql and tsql and connect to the mssql server and query the database. The problem occurs when I try running a php script. I get an error when attempting to connect to the database:

[unixODBC][FreeTDS][SQL Server]Unable to connect to data source

I tried using logs to find the problem:

util.c:288:Starting log file for FreeTDS 0.64
on 2007-06-06 09:25:58 with debug flags 0x4fff.
iconv.c:195:names for ISO-8859-1: ISO-8859-1
iconv.c:195:names for UTF-8: UTF-8
iconv.c:195:names for UCS-2LE: UCS-2LE
iconv.c:195:names for UCS-2BE: UCS-2BE
iconv.c:361:iconv to convert client-side data to the "ISO-8859-1" character set
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:168:Connecting to (Server IP) port 1433.
net.c:237:tds_open_socket: (Server IP):1433: Permission denied
util.c:119:Changing query state from IDLE to DEAD
token.c:2252:tds_client_msg: #20009: "Server is unavailable or does not exist.". Connection state is now 4.
mem.c:519:tds_free_all_results()

I read that this may be due to bad permissions on my freetds.conf file which prevents the user apache from using the file but I tried changing the permissions of the file and my results did not change.

I then used the exact same installation process on a computer that is running Centos4 and php 4.3.9 and I was able to connect and query the database using my php scripts.

Please help me, I am new to FreeTDS but I have been looking all over the place for a solution to this problem with very little luck. I would be very grateful for any and all help in resolving this issue. Thank you!

_________________________________________________________________
Play games, earn tickets, get cool prizes. Play now–it's FREE! http://club.live.com/home.aspx?icid=CLUB_hotmailtextlink1





Archive powered by MHonArc 2.6.24.

Top of Page