FreeTDS and PHP
James Kirsop <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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