Skip to Content.
Sympa Menu

freetds - [freetds] FreeTDS and PHP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Kirsop <james.kirsop AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] FreeTDS and PHP
  • Date: Wed, 12 Jan 2011 10:20:55 +1100

Hi all,
I'm not sure if this question is best suited for the FreeTDS list, but I'm hoping someone on here can help me.

I'm trying to get PHP talking to a MSSQL server through FreeTDS. I can connect to the server via both tsql and isql on the host machine where PHP is installed, but can't seem to connect via PHP its self with the following error appearing:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC] [FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000 in SQLConnect in/var/www/html/odbctest.php on line 3

Line 3 (the connection line of the script) is as follows - with usernames/passwords removed:
$connect = odbc_connect("DARACW", "username", "pass");

I also get a variety of error messages following this, as a result of the $connect variable not being created successfully.

I've looked through logs and things like that, where I would expect to find information but haven't found anything as yet. If anyone can offer suggestions on what to look at or for it would be appreciated.

Thanks in advance!
James




Archive powered by MHonArc 2.6.24.

Top of Page